How to display the 2nd section in Delimited text (CSV) format?

[lookingforK]

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.