CSV export with Stacked lists

[Neo310]

Hello All!

I am trying to create an upload file and it requires a header, body and trailer record.  I have build 3 separate lists and stacked them on top of each other.  When I run to HTML, it looks great.  When I run to CSV and then open as TXT file, it only displays the header record.  The only way I can get it to work is 1) export to Excel, then save as CSV, then right click open w/ Notepad.

Is this just a cognos or excel limitation?  This is a lot of steps for the user.  Ideally, i'd like them to be able to just export straight to csv and open w/ notepad. 

Please help!  Thank you!

[dougp]

That's exactly what it should do.

https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=results-view-output-in-microsoft-excel-format

The CSV output format produces a list containing the output from the same query.  That means not only that you only get one output, but that what appears on the page doesn't really matter.

If you want CSV, and don't want to confuse your users, your report should be a single list that contains everything from the query.  No header, no footer, nothing besides the list.

[Neo310]

Thank you doug - i could try to create a union query that merges them all into one list.

Appreciate your fast response!