Search code examples
visual-studioreporting-services

How can I have the grouped variables in an SSRS report show up on each page, either on the footer or header of the page?

I have a main report with several subreports, all within a tablix. The report is grouped by an Investor Id value and the details for the Investor Id span multiple pages when its printed. My issue is that I'm not able to display the investor id on each page, either on the footer or the header. I just need it to show up for each page, I don't care if its on the bottom or the top. Can this be done?

image

image 2

Solution

  • I've tested this and it seems to work fine, and it's simple.

    First, click your ID row group in the row group panel below the main designer and then hit F4 to get to the properties. In the properties window, expand the "Group" section and set the PageName property to whatever you want to show in your header (e.g. ="Investor ID = " & Fields!ID.Value).

    Next, set the PageBreak to Between

    enter image description here

    Now, in your header add a textbox and set the expression to be =Globals!PageName.

    That's it, the pagename property will change for each value in the dataset in your main report and be applied to the header on each page.