Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: vamsivanka on 17 Apr 2015 10:28:14 AM

Title: How to export data to Excel from Mutliple Pages
Post by: vamsivanka on 17 Apr 2015 10:28:14 AM
We have a report with Multiple Pages in the Report Studio.

First Page Shows "Details Data" and the second page shows "Summary Data".

When we run the report and export the data to Excel "View in Excel 2007 Data" all i get is the "Details Data" from the first page. Is there anyway to export the "Summary Data" too ?

Thanks.
Title: Re: How to export data to Excel from Mutliple Pages
Post by: adam_mc on 17 Apr 2015 11:10:31 AM
Try the "View in Excel 2007 Format" option.

This should give you a single Excel output with 2 tabs (probably named Details Data_1 and Summary Data_2).

Hope this helps.
Thanks,
Adam.
Text only | Text with Images