We are trying to run the Revenue by Source and Appeal report to see both contributions and tickets that were processed with a particular source. When we run the report, we are getting nothing for the source. If we run the Appeal Response report, we get ticketing money. I can't figure out why the money won't show up in the other report. We actually have orders and contributions that were processed with the source, but the money isn't showing up. Any ideas of what we are missing with this report?
I haven’t done that, but have been working for a while now to try to make the campaign parameter multi-select, and am struggling with it…it’s quite a report isn’t it?
Penny Tabor
IT Manager
Midland Center for the Arts
Midland, MI 48640
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James Fairfield Sent: Thursday, March 29, 2012 3:41 PM To: Tabor, Penny Subject: [Tessitura Technical Forum] Revenue by Source and Appeal report
Hi
I am trying to modify the Revenue by Source and Appeal report for our development department to be able to break out the money by Ticket order or Contribution. Has anyone done this before or do you know how to do it? I have tried several approaches to this, and nothing seems to be working.
Thanks, James
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Try using this where you find @campaign:
charindex(','+convert(varchar,a.campaign_no)+',' , ','+@campaign+',') > 0
James