I have developed SSRS report for Excel and I want to repeat header on each page.
In my report i have One parent group inside that child group in this child group there is one more child group.
For header to repeat I checked "Repeat header column in each page" from tablix property, but it did not work.
Also from Advanced Tablix Member Properties for Group I have set static properties as follows:
RepaetOnEachGroup - True
KeepWithGroup - After
FixedData- True
but on preview I am getting error as invalid parameter for Tablix is KeepWithGroup set to None and RepeatOnEachGroup set to False.
Is there any solution for this.