Hello!
Does anyone have a report they can share with the following three fields? For a date range, campaign, & list, I need to pull:
1. Name
2. Date of Contribution
3. Contribution Amount
Essentially it's a Fund Activity Report with contribution dates. I can't use the New Contributions report because it doesn't pull by campaign. Help!
Thank you!
Jessica
We have various custom reports, but to get the kinks worked out in order to specify those, we start with Development > Current Constituent Giving by List. I normally go wide with the date parameter and filter any outlier campaigns in the Excel output: this to be sure to pick up contributions that jump the start/end of fiscal years.
John Trimble Data and Prospect ManagerDallas Symphony Orchestra Morton H. Meyerson Symphony CenterSchlegel Administrative Suites2301 Flora Street Dallas, Texas 75201-2413 214-871-4041 - phone214-981-2988 - faxj.trimble@DalSym.comwww.MyDSO.com
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jessica BlaisusSent: Monday, September 08, 2014 2:41 PMTo: John TrimbleSubject: [Tessitura Development Forum] Name-Date-Contribution
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 Jessica,
We have a Custom Fund Activity Report that will give you this information. The Santa Barbara Centre for the Performing Arts will put it up on the Shared Reports workspace this afternoon, that way you can download the SQL files and so forth.
Hope it works for you!
-Jessica
Jessica Simon
Sponsorships & Special Events
Lobero Theatre Foundation
*Please note my new phone number 805-679-6007*
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Jessica Blaisus Sent: Monday, September 08, 2014 12:37 PM To: Jessica Simon Subject: [Tessitura Development Forum] Name-Date-Contribution
Thank you! I look forward to seeing it!
Jessica,
Have you tried the Pledge Gift report in the Finance folder?
Dale
An Output Set could be built to return this information. There are several elements in the Output Set Cookbook where a contribution date range and fund can be specified. There is also general documentation about Output Set Builder available too; if you're not familiar with it already, it's a powerful tool for outputting data without custom reports.
-Michael, Tessitura Network