Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving Impromptu report in Excel with Headings

Status
Not open for further replies.

worldofchandran

Technical User
Mar 16, 2007
15
US
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?
 
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 [pc2]
Want good answers? Read FAQ401-2487 first!
 
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é
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top