How do I stop the header from duplicating? I have seen tutorials that mentioned by default the header will remain, while the data row will populate more lines? Thanks in advance.
Hi Daniel,
This might be useful!
The easiest way to deal with table headers which you want repeated on every page is to move them into the PAGE header area.
If you look on the left of this image, there are two white bars (sliders) I circled in green and yellow. The green is the Header slider, you can move this to resize your header. Anything above that will repeat on every page. So, you can see in this example, I’ve created textboxes which line up with my table so they will appear as a table “header row” at the beginning of each page.
Even if you have a “tablix” which repeats several times in your report… you want to make sure your header row is outside of the detail group(s) (which repeats with every data row). These can get messy and confusing… but, in the below image if you look at the red box and see the 3-horizontal lines. This is my main “details”. The group rows are highlighted in red. There is a parent group highlighted in yellow, and another parent group highlighted in green.
There’s yet another parent highlighted in blue. In this case, I would want my headers to appear in the BLUE group. The Blue Group will show once per tablix, the green group will repeat as many times as it needs to for the data… the yellow group will repeat as many times at it needs to inside the green group and the red group will repeat as many times as it needs within the yellow group. But the BLUE group will only print once per tablix… so that’s where you’d put your headers.
Hope this helps.