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?

CodePudding user response：

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

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.