I'm trying to find a way to output from a List I've created of group bookers their booking history including what they attended, when, total tix booked per performance and total income in £. I want to analyse their buying patterns in order to devise some specifically targetted campaigns. Any one help?
Hi Helen,
You can create an output set with the following criteria: Ticket Production, Ticket perf date, Tickets Number of seats and Tickets Total amount. Then go to Reports and Utilities and Execute an Output set using the output set you have created and your list.
Hope this helps,
Thanos
Thanks for your suggestion. I tried it but came up with a system error message - think it might be a problem at our end rather than tessitura:
SyntaxFromSQL caused these errors: SQLSTATE=42000 MicrosoftOLE DB Provider for SQL Server Ambiguous column name 'customer no.' execute dbo.RP_Run_QUERY;1@query_no=77,@list_no=0