We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
Ok, so i'm sure this is probably one of the easiest things to do but alas, I do not know the answer. I'm creating a report that lists all of our donors over a certain dollar amount for the month and am producing just their names, adress and phone. My question is, how do i format to get more than one phone type to print out in the report..if they have a home phone, cell or email..or all three..I want all phone types to show.
If you are exporting from RE to an bb report writer database format,
export all phone types and associatedl numbers.
In your report create a detail set. Insert a text box and then insert your phone types & numbers, check the "supress blank lines" in the text format box and that should work.
__________________ Elaine Tucker Stewardship Coordinator St. Mark's School of Texas USA www.smtexas.org
Go to Profiles, Lists and Directories
Try a constituent directory
What I like to do is print two addresses (which is an option on this report) so you can get their home and business info (if they have it)
I think it is a fairly good report (I only wish I could add attributes to it.)
If you are exporting from RE to an bb report writer database format,
export all phone types and associatedl numbers.
In your report create a detail set. Insert a text box and then insert your phone types & numbers, check the "supress blank lines" in the text format box and that should work.
This depends on exactly how you "export all phone types." If you just have one field and do not further filter it, this approach won't work, because each phone type will be in it's own record, so the text box will only contain one phone number and the address will be repeated for each phone type.
I recommend that you add a separate field for each phone type that you want to include and filter it so that only that phone type shows in that field. In that scenario, Elaine suggestion would work, because you would be pulling different fields from the same record instead of the same field from different records.
Drew
__________________ J. Drew Allen
Children's Hospital of Philadelphia
Crystal Reports and SQL Server Consultant
It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection.
Melissa, thanks..i realize now the directory is the way to go! i just never looked at it in depth but it's exatly what i need. I'm just now learning Crystal Reports so i thought i would do it that way but this is so much easer. I must stop trying to reinvent the wheel!!!! Thanks again.
This depends on exactly how you "export all phone types." If you just have one field and do not further filter it, this approach won't work, because each phone type will be in it's own record, so the text box will only contain one phone number and the address will be repeated for each phone type.
I recommend that you add a separate field for each phone type that you want to include and filter it so that only that phone type shows in that field. In that scenario, Elaine suggestion would work, because you would be pulling different fields from the same record instead of the same field from different records.
Drew
Drew,
Thanks for pointing that out..I've done it so much that I forgot that little detail.
__________________ Elaine Tucker Stewardship Coordinator St. Mark's School of Texas USA www.smtexas.org
Linear Mode
