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 don’t have to create a temp table to store campaign_no values first, then joining to the temp table? That is what I was doing. Along with changing the parameter to a string (@campaign_str).
So, are you saying instead of “Where a.campaign = @campaign” I would instead state
“Where a.campaign = charindex(','+convert(varchar,a.campaign_no)+',' , ','+@campaign+',') > 0
Penny
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James Fairfield Sent: Thursday, March 29, 2012 4:11 PM To: Tabor, Penny Subject: RE: [Tessitura Technical Forum] Revenue by Source and Appeal report
Try using this where you find @campaign:
charindex(','+convert(varchar,a.campaign_no)+',' , ','+@campaign+',') > 0
James
From: Penny Tabor <bounce-pennytabor2237@tessituranetwork.com> Sent: 3/29/2012 2:58:07 PM
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!
Up in the parameters section of the stored procedure, you do this:
@campaign VARCHAR(MAX), -- changed from INT
or if they only plan to use a few campaigns as a string you can go smaller VARCHAR(255).
Then there are a few places to do this (no equal sign):
Where charindex(','+convert(varchar,a.campaign_no)+',' , ','+@campaign+',') > 0
AND other criteria.....