Hello!
I'm formatting a crosstab report with dynamic pivot query using crystal report and I find it hard to format my fields. First, I still used the crosstab report wizard then format it but the dates and amount fields does not appear. Second, I used
the standard template but I don't how to lay out those fields and until now I'm doing a trial and error to figure this out.
This is what my crosstab report look like in the query.
First column is the Customer_ID then the succeding columns were their total purchases per day.
10/25/2012 10/26/2012 total
100016 990.00 660.00 1,650.00
100018 990.00 660.00 1,6500.00
206007 0.00 660.00 660.00
total 1,980.00 1,980.00 3,960.00
Should I use standard report then drag and drop my fields or still use the cross tab wizard then customized it?
Thanks,
Regem
