Saving Impromptu report in Excel with Headings

[worldofchandran]

Hi All,
I need some help in saving the impromptu reports developed in version 7.1 in Excel 2003. Right now when I save the reports the header of the report doesnot show up in the Excel. Is there a way of including the header in Excel?

 

[elalacran]

Have you tried to save it as type Ecxel with Format (*.XLS) ?

 

[griffindm]

For that version you need to create a dummy group header and move the report objects you would normally place in a page header into this dummy group header. Hide the page header, set the new dummy group header to repeat on each page and to page break before, and you have a report that will save with header info into Excel when run with the "w/Format" option.

Regards,

Dave Grifin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[drlex]

worldofchandran,
You mention that the reports are 'developed in 7.1'. If you're using 7.3, you can set the reports to save as 'Excel 2002 and higher' (Menu bar:Reports>Excel), which will include the header. It may, however, have unwanted side-effects on the formatting of the output.

soi la, soi carré

 

[worldofchandran]

Thanks all for the information.