This is an older help file. This particular feature can be accessed by going to
Reports | Other reports | Count of performances attended.
The built-in report is much easier for this .
There is no specific report to answer this question. Therefore, you need to use the Mailing list | Generate a mailing list | Export email function. This allows you to paste.
You have opened up an interesting world: the world of extracting data. In its basic form, the query you want to paste into Wintix is:
select count( mainsale_id ) as salecount,
customer.first, customer.last, customer.title, customer.company, customer.address, customer.city, customer.state, customer.zip, customer.phone
left join customer on customer.customer_id=mainsale.customer_id
group by customer.customer_id
having salecount > 50
order by salecount
It looks like this:
- Send output to a dbf when testing – it’s faster.
- The query is intended to give only a few results to make it easier to see the results. For more realistic results, change the line having salecount > 50
to a more reasonable number.
- There is a bunch more stuff you can do here. Entire books have been written about this subject. The key is to start simply with a clear idea in mind of what you want to do.