Revenue by Source and Appeal Report

Hi Teresa,

The campaign you select when you run this report determines which products (i.e. performances, packages, and fees) are included in the report based on the campaign to which they products are assigned.  It does not affect which appeals and sources are included in the report.  After it selects the products based on the campaign you selected, all sources used for sales of those products are listed.  For example, if I select my 2011 Single Ticket campaign, all sales of performances in that campaign will be included in the report broken out by the sources used for those sales.  Does that make sense?  It sounds like you are selecting a campaign that has not been assigned to any products.  This all works the same for contributions, too.  The campaign you select controls which contributions are included in the report and then the contributions are broken out by the sources used.

Kevin Sheehan

Senior Documentation & Learning Resources Specialist

Tessitura Network

+1 888 643 5778 x 329

ksheehan@tessituranetwork.com

Thanks Kevin and Ryan, what you both say makes sense and when looking at everything, that’s exactly what the issue is.  Thanks for the clarification!!

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!

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

That seems to have done it!!!!  Thanks so much!!! It was really starting to frustrate me.

Penny

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James Fairfield
Sent: Thursday, March 29, 2012 5:36 PM
To: Tabor, Penny
Subject: RE: [Tessitura Technical Forum] Revenue by Source and Appeal report

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):

Wherecharindex(','+convert(varchar,a.campaign_no)+',' , ','+@campaign+',') > 0

AND other criteria.....