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.
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.