Hi all, I have a report which based on a crosstab query, and I add a grouping by using the group&sort button on the design toolbar. The grouping is on one of my crosstab query row head.
Now I want to export report to excel with each grouping as an individual worksheet in one excel file, which means multiple worksheets in one excel but based on only one crosstab query and grouping report. Can anyone give me some thought about how to achieve this?
Thanks a lot!!!
Now I want to export report to excel with each grouping as an individual worksheet in one excel file, which means multiple worksheets in one excel but based on only one crosstab query and grouping report. Can anyone give me some thought about how to achieve this?
Thanks a lot!!!
