Hi All,
I currently use the Performance Seating Book Report to find our donors who are in attendance at each days performance. I then have to search through each record to find their most recent gift. Is there a report anyone knows of that will create that criteria for me? All I want is Name, Seat Location, Most Recent Gift on a day by day basis that I can run every morning for that evenings performance. Thanks!
~Joe
Hi Joe,
Do you need the exact value of the gift or would membership level and status suffice? If the latter works for you, I'd recommend the performance report as it lists membership level. This is a different report from the performance seating book, and it lives in the development reports folder.
Sheila
Hi Sheila,
Thanks for the response. I’m searching a pretty broad span of dates trying to get something and nothing comes out. So I’m assuming we have a customized ticketing structure as it says that might be the problem. Thanks for the help though!
JOE JANKOWSKI
Development Associate | The Joyce Theater Foundation, Inc.
175 Eighth Avenue New York, NY 10011
T 646 278 0444 | F 212 463 0363
jjankowski@joyce.org | joyce.org
GET CLOSER TO DANCE
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sheila Kearney Miller Sent: Thursday, August 11, 2011 12:47 PM To: Joe Jankowski Subject: Re: [Tessitura Development Forum] Member Daily Seating Report?
From: Joe Jankowski <bounce-joejankowski8857@tessituranetwork.com> Sent: 8/10/2011 11:36:22 AM
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!
I don't normally pull that report; but I assume you could also save the report to a list and use an output set to pull your giving history. Then just merge the two documents in excel? That would at least prevent you from having to go into each individual record.
The problem with saving to a list (which would get my correct output), is that I do the same thing every day - that would lead to a lot of lists. I was hoping there was a report out there that could do that for me, so each day I would just go in and change the date and get the same output. Ah well! Thanks though! Hope all is well Marisa
The Devo 'Performance Report' (AP_PERFORMANCE_REPORT) does ultimately reference a non-local view named VS_TCK_HIST which is probably empty due to your custom ticket history. The report however first queries a local view named LV_TKT_HIST_REPORT, which in turn queries the VS_TCK_HIST view.So you can point LV_TKT_HIST_REPORT to a local view of your ticket history, but you will still probably need to edit the columns that are being selected for the actual report.(and possibly make a local version of the report itself) Edit: looks like the report is a "System Window" report which means that you can't actually make a local version of it, but you can probably still tweak the views enough to make the standard report work for you.
Not sure if that makes any sense, but you can check with your IT dept to see if they can make that report work for you.
Cheers!