Hi,
I am using Cognos Report Studio 8.4 to create a report that has 2 sections.
If I run report with Delimited Text (CSV) format, the output Excel spreadsheet only shows the 1st section.
But, if I run report with PDF format, the output PDF file shows the both sections.
How to display the 2nd section in an Excel spreadsheet with Delimited text (CSV) format?
For example:
I used query1 object for the 1st section. Query1 object includes some data items, e.g.:
Store Size
Sales This Week
Sales Last Week
Sales YTD
...
I used query2 object for the 2nd section. Query2 object includes the following data items like:
Product Class Type (*)
Sales This Week
Sales Last Week
Sales YTD
...
But, if I ran report with Delimited Text (CSV) format, I only got the 1st section in the output Excel spreadsheet.
No problem with PDF output and 2 sections show up. Why?
How to deal with this issue?
Thank you in advance.