Topic
  • 2 replies
  • Latest Post - ‏2009-01-07T21:00:41Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic How to repeat page header/footer for each page in Excel, page setup to landscape

‏2009-01-07T21:00:41Z |
  • said:

    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?

    Thank you,

Updated on 2009-01-07T21:00:41Z at 2009-01-07T21:00:41Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: How to repeat page header/footer for each page in Excel, page setup to landscape

    ‏2009-01-07T21:00:41Z  
    Suraj 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.

  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: How to repeat page header/footer for each page in Excel, page setup to landscape

    ‏2009-01-07T21:00:41Z  
    Smit 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.