locked
SSRS Cover Page In Front and Between Reports RRS feed

  • Question

  • Hello,

    I have an ongoing report which has around 170 pages and need to add different title/cover pages in front and between reports (e.g. chapter numbers on a book), and I'll be exporting this to pdf file. Cant find a good tutorial how to do this. Im currently using Visual Studio 2013. Any help would be appreciated.

    Regards,

    Rob

    Thursday, August 6, 2020 2:07 AM

All replies

  • Hi Rob,

    I have an idea like shown below. Hope it can meet your need!

    1.Insert Page Header.

    2.Insert a text box in the page header.

    3.Add Expression in the text box like this:

    ="chapter"+Switch(Globals!PageNumber>="150","4",Globals!PageNumber>="100","3",Globals!PageNumber>="50","2",Globals!PageNumber<"50","1")

    In this way you may need to check the pages number and chapters.

    Regards,

    Zoe



    • Edited by Zoehui-MSFT Thursday, August 6, 2020 5:41 AM edit
    • Proposed as answer by Zoehui-MSFT Tuesday, August 11, 2020 3:42 AM
    Thursday, August 6, 2020 5:40 AM