I have one problem about combining many reports with different layout and query but the same data source and every report contains crosstab. As user used to use excel as her report. In excel file, there are many different sheets. Then I design one report for one excel sheet. So in order for user to produce report as their excel file, they have to run many times different reports which also export in different excel file and combine it manually which is not convinient for them.
Could anybody tell me how can I archieve this which user need to run only one time and she will get result as her excel worksheet?