Having an issue with Ticket count by payment method by mode of sale. Now I KNOW this can't be done. I have gotten the official word that this can't be done and have always known this couldn't be done. But...
There are certain promoters and or traveling shows that require this kind of break out and I can not possibly be the only one that is required to provide this break out to them.
Is there anybody willing to share their code to help with this. I can't even get close. Maybe you have some sort of work around like dumping the ticket counts into the first payment method of a split payment lineitem.
Would appreciate any help or guidance.
Thanks,
Marty
Marty,
We don't report on ticket count by payment method and mode of sale (although we are constantly asked about it), but we do report on payments by mode of sale and payment method. I've uploaded our report to my files area if you want to take a look at it.
I've played around a little with trying to connect t_order_seat_hist to t_transaction/t_payment based on the date time stamp but I've never had enough time to see if I could make it work. (If Chuck is listening, if we could get the transaction_no added to t_order_seat_hist for all of the money events we could report on this easier, I think - I keep meaning to submit an enhancement request for this).
Please share anything you come up with on this - I hate telling our presenters we can't give them the information they need (especially when they say they can get it from other places that use the evil ones).
-steve carlock
Santa Barbara Center for the Performing Arts/The Granada
Hi Steve
I sent Marty a copy of our Stored Procedure and he has reported that it worked on their data with minimal local tweaking (i thought we may have customised it too much but apparently not).
So if youre still interested in a Ticket counts by Payment Method report (using our highest-value-gets-the-count model) report let me know.
(and yes ... our report also came out of a determination to match whatever presenters say they can get from the other side)
Peter
Hi,
I would be very interested in the report you mention, as we are going to have to start reporting this way soon.
Thanks,Caryl
Hi Caryl
Ive uploaded three files to my profile - the SQL code (which is based on Tessitura's RP_PMTS_BY_PERF_NEW), xml file for Report Setup and a sample of the rep (a bit dull visually but we use this as a subreport of a bigger (more attractive!) post event suite).
I didnt include a pbl as the output is quite easy to group. Note in the SQL there is some now redundant code to do with calculation of CC commissions which you can ignore.