I don't know if this can be done.
I am looking at transactional data for a specific date range by customer.
I wanted to create something like this:
Cust# Name 01/01/12-01/31/12 02/01/12-02/29/12
0123 ABC Co $15,523.12 $20,123.78
Right now I'm running a January report, then a February report (and so on) in crystal, exporting to excel. Then I combine the excels into crystal matching on the Cust#.
Just looking for an easier way to get the sales $ for each month in one report.
I've done subreports too. It just takes forever to spin through the data.
I appreciate any help. Thanks in advance!
I am looking at transactional data for a specific date range by customer.
I wanted to create something like this:
Cust# Name 01/01/12-01/31/12 02/01/12-02/29/12
0123 ABC Co $15,523.12 $20,123.78
Right now I'm running a January report, then a February report (and so on) in crystal, exporting to excel. Then I combine the excels into crystal matching on the Cust#.
Just looking for an easier way to get the sales $ for each month in one report.
I've done subreports too. It just takes forever to spin through the data.
I appreciate any help. Thanks in advance!