I'd like to generate a list of annual fund contribution amounts for each person who contributed to the FY13 annual fund campaign, but I can't find the utility I need to pull this information. I have a list of the donors I'd like this information on, but when I try to create an output set, it will only pull data from last contribution or it comes back with more data fields than I need. Help!
Others please correct me if I am wrong, but this may be a custom element. I do not personally use or know of a canned element to do this.
I have an output set element called “Contribution Campaign _P* ”. The P means that I can select a parameter – in this case I can select 1 or more campaigns of my choosing. The * means that this will potentially give me multiple rows for people in the data output.
If you have a DBA or someone who can create this for you, reach out to them.
I hope this helps
Marie
--
Marie Kocher | Development Assistant
Kansas City Ballet
Todd Bolender Center for Dance and Creativity
500 W Pershing Road
Kansas City, MO 64108
816-931-2232 x 1382 | 816-931-1172 (fax)
mkocher@kcballet.org
Buy tickets and enroll for classes: www.kcballet.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Rachel Assi Sent: Thursday, September 26, 2013 3:19 PM To: Marie Kocher Subject: [Tessitura Development Forum] Pulling Contribution Data from Campaign
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!
Hi Rachel,
Without knowing specifically what your setup and needs are, I would guess a report might be an easier way to arrive at that than an output set. I always think the Fund Activity Report (in the Finance folder) is a good place to start.
Otherwise I believe Marie is correct--you would need a custom output set element. There's a really helpful document you can download called Output Set Builder Cookbook that has lots of great examples of custom output set elements. Take a look at the section "Total Received Amount and Last Date Contributed per Campaign Within a Date Range." That might in fact be exactly what you're after.
Good luck!