If you’ve ever had the following issues displaying Tablix reports, read on for the solution to your problems.
- Do you want your report headings on each page of your AX SSRS report?
- Are you trying to display your headings from a tablix?
- When you have your headings in a tablix on the report, the tablix property “Repeat Header Columns on Each Page” will NOT work.
Use the following steps to solve Tablix Report Headings:
1. Click on the Tablix that contains the headings you want to display.
2. Turn on Advanced Mode in the Row/Column Groups window.
3. You will see the Static lines now displayed in the window.
4. Select a static line that is part of your heading (usually above the groups that you created).
5. Open the properties window (F4).
6. Set the KeepWithGroup property to After.
7. Set the RepeatOnNewPage property to True.
8. If you have multiple heading lines that you want on every page then do this for each static line in the heading.
That’s it! You should now have your headings displayed on every page of your AX SSRS report!