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. :-)