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
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!