Export Sub Report to Excel

[kamkaro]

Hi All,
I have 1 Main Report and 3 Sub Reports (same Database), and would like to Export into Excel file/format. Please see the following questions where I am facing issues;

1) If I choose on-demand and Suppress option in Sub report format, I am not able to see Sub Report data in Excel.
2) If I choose on-demand option only in Sub report format, I am not able to see Sub Report data in Excel.
3) If I do not choose either on-demand or suppress Option in Sub-Report, I am able to see Sub-Report data.

User wants to see only Summary data on Main Report and would like hide or on-demand sub-reports data, Could you please give me any idea how do I achieve this scenario.

Appreciate that.


Thanks.

 

[hilfy]

Simple answer, you can't. The Excel export will not export anything that is not visible on the report.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com