SSRS - Dynamic group repeat headers on each page

Hi,

I am working on a complex SSRS report in which the grouping headers are dynamic. I want to repeat grouping headers on each page but i am not able to find do it. i tried "Repeat row/column header on each page=TRUE" but it does not work.

Example is given below

Employee E1 (Group)
- Department D1 (Group)
  - Salary Month Jan-2022 (Group)
    - row wise Details of E1 ( 31 days attendance , salary amount, over time data, tax amount for month etc...)
  - Salary Month Feb-2022 (Group)
    - row wise Details of E1 ( 28 days attendance , salary amount, over time data, tax amount for month etc...)
Employee E2 (Group)
- Department D2 (Group)
  - Salary Month Jan2022 (Group)
    - Details of E2 ( salary amount, over time data, tax amount for month etc...)

Please let me know how can i repeat group headers on each page ?

The Repeat header rows on each page setting only works for static rows in the tablix header and not for group headers unless configured carefully.

In your Tablix, you need to define row groups for Employee, Department, and Month.

In the Grouping pane at the bottom of the SSRS designer, click the small arrow in the Row Groups or Column Groups pane to open the Advanced Mode.

This reveals static and group rows in the hierarchy.

For each group header row (Employee, Department, Month):

Click on the corresponding static row in the Row Groups pane (under Advanced Mode).
In the Properties pane, set:
- RepeatOnNewPage = True
- KeepWithGroup = After (for headers before group data)
- FixedData = True (optional: for freezing on scroll in interactive mode)