burst report in csv and then spread data accross worksheets

[lifzgud]

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?

[rockytopmark]

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.