Page Header In Reporting Services coverpage issue when export to word

问题 Page Header In Reporting Services coverpage issue when export to word

  • Wednesday, January 23, 2013 9:31 AM
     
     

    Hi all,

    In sql server reporting services,i need to display page header(contains logo) in other pages only except in coverpage.can any one tell me how to suppress or hide page header in coverpage when i export in to word.

    Thanks....


All Replies

  • Thursday, January 24, 2013 5:17 AM
    Moderator
     
     

    Hi Chaitanya,

    If the cover page in the first page of the report, you can specify the page header property "PrintOnFirstPage" to "false". In that case, the page header will not display in the cover page.

    For more information, please see:

    How to: Hide a Page Header or Footer on the First or Last Page (Reporting Services)

    If I have any misunderstanding, please let me know.

    Regards,
    Fanny Liu  


    Fanny Liu
    TechNet Community Support

  • Thursday, January 24, 2013 7:28 AM
     
     

    thanks for reply,

    the report looks like ,header ,coverpage,under cover page have 10 reports,footer and the (note:coverpage and 10 reports are in Rectangle box)

    I kept "PrintOnFirstPage" to "false" before only .But when i select multi select (eg:chenni,mumbai....)  in the parameter ,the 1st cover page it was not comming the logo in cover page ,but for second  parameter ,the logo was cmg when preview the report and export in word also.please help me.

    thanks...

  • Thursday, January 24, 2013 9:17 AM
    Moderator
     
     

    Hi Chaitanya,

    I create a similar report in my test environment and try to meet the requirement by specify the visibility of the "logo" based on the page number. However, after export the report to Word, all pages keep same with the page header of first page. It may be caused by the limitation of the Word rendering extension.

    To work around this issue, you can try to add the logo inside the report body. For example, add a new rectangle inside the box and specify the "RepeatWith" value as the data region which display the report.

    Regards,

    Fanny Liu 


    Fanny Liu
    TechNet Community Support

  • Thursday, January 24, 2013 10:59 AM
     
     

    Thanks for Reply...

    If I kept "PrintOnFirstPage" to "false" ,the 1st parameter logo was not comming  in cover page  .But when i select multi select (eg:chenni,mumbai....)  parameter ,the 1st parameter logo was not comming  in cover page ,but for second  parameter ,the logo was comming  when preview the report and export in word also.So how to remove the logo in cover page when i select multi parameters? please help me.

    please send some screen shots. Thanks....