I had to recreate a report that used the cross tab format to calculate several distinct counts. The user insists getting the information in EXCEL. Crosstab was no an option due to all of the formatting issues when exporting to EXCEL.
Two groups: Sales Terr and Clients.
Need distinct counts for each client and the total count for all the clients under a sales terr.
Need the above for each month in the last year as well as the grand total for the whole year.
Jan Feb Total (Jan + Feb)
Sales terr 1 3 2 5
Client A 1 0 1
Client B 2 2 4
Sales terr 2 1 0 1
Client C 1 0 1
GRAND TOTAL 4 2 6
There is a subreport for each of the distinct counts that need to get calculated. I do have subreport links set up for each of them. The report works fine, but it takes forever to run.
The Main report has a selection criteria for the records for the whole year. Each of the subreports has a selection criteria for the Month that they need to return the counts for.
I am sure that there is an easier and more efficient way to do this. OR is there a simple way to improve performance on the existing report?
Any suggestion is appreciated!!!