Rendering Cognos report as Excel report with named sheets

[brain1e55]

Is there any chance to have a report in Excel that should be separated into worksheets named on basis of some data item, e.g. department name or something alike. Let's assume that I have Cognos report with sections and I need to have every section in new excel sheet with appropriate name. Is it possible? Any suggestions?

Thanks.

[krogovin]

Hi!

If you create separate pages in your Reportnet Report and name them, when the report is exported to Excel, each sheet will represent each page.  I don't know how to make the name of page dynamic, though.