Hello all,
I have looked in the forums and cannot find what I'm looking for and hopefully someone can help.
We're looking for a report for scanned tickets for when they were scanned and pricetypes.
If anyone has as ideas or reports on how to find this out rather than going through each order individually that would be great.
Thanks
Meagan Keam
EPCOR Centre for the Performing Arts
Calgary, AB
There is no standard report that will tell you the date and time when a ticket was scanned.
There is a standard report that will break out attendance figures by price type, though. See the Attendance by Performance report.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
Thanks Guys
I totally forgot about that report and that will do great for the pricetypes but we really more need the time of attendance. We're trying to track when everyone typically goes into the theatre and whether they're the comps or paid tickets.
While there isn't a canned report that will give you the exact time of attendance ticket by ticket, there is a table, LT_NSCAN_ATTENDANCE, that records every scan, in and out, successful or otherwise, of every ticket. You could write a report against that table (cross-referencing it to T_SUB_LINEITEM and T_ORDER as needed for more detail) to know at what time which tickets were scanned for what performance.