I have a report in Cognos Reports Studio 8.2 that has page header and footer which print fine in HTML and PDF but I need to have the header and footer print in every excel page.
Also is there any way when exporting to excel to make the page setup appear in landscape view rather than portrait?
Pinned topic How to repeat page header/footer for each page in Excel, page setup to landscape
Re: How to repeat page header/footer for each page in Excel, page setup to landscape2009-01-07T21:00:41Z in response to SystemAdminSuraj Neupane said:
To do that, you have to set pagination.
The easiest way is to insert a list in header and footer and format it so that it displays what you want in header and footer.
If you do that, it automatically repeats every page. It did that on my test report.
If not then select the header and footer list and in the properties, set pagination to repeat every page.
As far as the page setup of portrait and landscape goes, you have to do that from excel when printing.
Re: How to repeat page header/footer for each page in Excel, page setup to landscape2009-01-07T21:00:41Z in response to SystemAdminSmit Modi said: Cognos 8.2 doesnot provide functionality for page setup in Excel, as it does for PDF output, While in cognos 8.3 they have included this functionality for page set up in Excel format as well as in PDf format.