COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lifzgud on 22 Apr 2010 08:03:06 AM

Title: burst report in csv and then spread data accross worksheets
Post by: lifzgud on 22 Apr 2010 08:03:06 AM
Hi,
I have a slight complex reporting requirement.
I need to burst a report with country as the burst key.The report format is CSV.
Each burst report will contain multiple sheets(for each individual city) and then each sheet would have individual reports for that city.
Please let me know if this is possible?

Title: Re: burst report in csv and then spread data accross worksheets
Post by: rockytopmark on 26 Apr 2010 01:05:17 PM
Help me understand better what you are intending to have...

CSV is a simple text file, and there are no such things as "sheets" in a text file, only Excel files.
Furthermore, a CSV can be built in Cognos from a single query based object (List, Crosstab or graph) so if your report has more than 1 of these, you will not get desired output.

Cognos can surely burst a report into separate CSVs based on city, but there seems to be something more to your desired result that I am simply not getting.