Wednesday, March 25, 2015

SSRS - Repeat Header Section for A Tablix

How to repeat header section for a tablix:
    1. in the grouping pane, click on the small triangle and select "Advanced Mode" to show static members:


       
    2. verify that you have the properties grid turned on (in BI Development Studio use F4, in Report Builder go to the "View" tab and select "Properties")
       
    3. select the corresponding (static) item in the row group hierarchy
       
    4. in the properties grid:
      - set KeepWithGroup to After
      - set RepeatOnNewPage to true for repeating headers
      - set FixedData to true for keeping headers visible

No comments:

Post a Comment