Our Development department is wanting to produce a list of constituents and their contributions, with notes, for a certain fund by list. I have not found anything in the regular reports that can provide this for them. Is anyone using a report that can provide constituents and their contributions, with notes, for a fund by list? If so, would you mind sharing? Any help or guidance would be appreciated.
If you have already built your list and know that it has the records you were expecting, an Output Set would work. You can choose the elements you need and then run your list against it. Another option would be to maybe run a full bio report. You can choose “contributions” and “notes” on that report, and run your list with it. Those are my two suggestions.
Marie Kocher
Development Assistant
Kansas City Ballet
1616 Broadway
Kansas City, MO 64108
(816) 931-2232 x 1310
www.kcballet.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of David Roberson Sent: Friday, November 05, 2010 1:56 PM To: Marie Kocher Subject: [Tessitura Development Forum] Report for Contribution Notes
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Thank you for your suggestions. I tried both that you mentioned; however, neither was able to provide notes from the actual contribution entry. The notes for the Full Bio seem to only be research notes and not contribution notes, and I could not find a contribution notes criterion for the output builder. I appreciate the feedback.
Thank you. I will look into this.
If you are able to find a solution to your problem, please let me know. I believe this would be something that would be useful for us as well. Thank you!
Normal 0 false false false MicrosoftInternetExplorer4
Alaina Smith
Development Coordinator
Broadway Rose Theatre Company
503-906-2376 (direct line)
503-603-9862 (general admin. line)
alaina@broadwayrose.com
www.broadwayrose.com
This is the same question I have - I want to pull the Notes from the CONTRIBUTION not from Research. We have been unable to figure this out in Output Set Builder, but I'm hoping there's another way!
Anyone?
Thanks,
Amy Beth Nolte
Seattle Children's Theatre
Hi Amy,
I followed Sandra's advice on building the Output element for it. I added a Contribution Notes element.
1) in TR_QUERY_ELEMENT I added:
Description: Contribution Notes
Category: Contribution
Data Select: !.notes
Data From: (select a.*,fund_desc = b.description,camp_desc = c.description from t_contribution a JOIN vs_fund b ON a.fund_no = b.fund_no JOIN t_campaign c ON a.campaign_no = c.campaign_no)
I left Data Where blank, I did not choose a control group, and I did not check the Single Row check box.
2) I then created an Output Set using these elements (set yours however you would like):
Salutation_outside_line1 (for the name output)
Contribution_campaign_name
Contribution_cnt_date
Contribution_cnt_amt
Contribution Notes
3) Create your list of constituents that you want to look at and execute an output set using this new list and the output set you created.
4) The Output Set returns more information outside the dates or campaigns I'm looking for. I export the results into Excel and filter by the Campaign and or the date.
I think this is all the steps I used. It has been a while since I set this up. I'm sure there are better ways of doing this. It works for what we need.
I hope this helps.
David