Customer Acquisition by Location report

in
Category: 
Customer

This report details Customer Acquisition numbers by Practice Location and groups by year and month in specified date range.  To do this it uses the first date of a charge transaction for the customer rather than the created date as we need to find the location. The report is formatted as a cross tab with year and month vertically and location horizontally.  It has month, year and report totals.

For those who are interested thsi report uses the cross tab component in IReport which works brilliantly.  I was initially wondering hwo to get thsi format using SQL but didn't have to .. Jasper reports to the rescue.

If you find this report useful all I request is you find a suitable development project that needs funding and donate to it. :-)

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Customer Acquisition by Location report

Could you please clarify - does this refer to a previous veterinary practice ?

Syndicate content