sql-serverreporting-servicesreport-designer

Visual Studio Report Designer: How do I print something on every second page of a report?


I have a report in Visual Studio Report Designer that prints a contract. I want it to have certain terms and conditions on the back of every page. How can I print something on every second page (which I'll then duplex)? I've tried putting it in the page header\footer (it just gets cut off), and I've tried controlling the visibility of it in the body of the report using page numbers (but you can't use the global page numbers variable in the body of the report). How can I wrangle the report to do what I want?


Solution

  • Alas, as you already mention: you can't access the page number in the body of a report. I don't think your requirement can be satisfied, there's no real workaround that I know of. The only alternatives (which you may have already considered) I can see so far, ordered from bad to progressively worse:

    (Like I said, the workarounds were progressively worse from top to bottom :D)

    In the extreme case where you know exactly what content ends up on what page number you could link a visibility expression to that content.