Hello,
I have recently encountered an issue while trying to do the following in an SSRS report for AX 2012, inside a tablix control, in the Body section:
|
Header (static) line
|
Title line
|
Should print on all pages
|
|
Header (static) line
|
Address line
|
Should print only on first page
|
|
Header (static) line
|
More information line
|
Should print on all pages
|
|
Details line
|
Group line(s)
|
Should print on all pages
|
Because the tablix control is located in the Body section of the report, I cannot access the global variables related to page numbers, so I cannot set the visibility of the second line based on that.
Also, I cannot put these lines in the header of the report because the white lines of space in the header when a line is not shown are not acceptable, and the header is not resizeable at runtime.
I have also tried the following, with no success:
- Set property „Repeat on new page” for each line accordingly, but SSRS will not allow consecutive lines to have different values for this property (so they must all have „true” or „false”).
- Insert new field in datasource which will contain the record number or page number and use this value for showing or hiding the line : this doesn’t work because the header of the tablix only reads the first records from the datasource, even if the controls are printed on the second page.
- Try to use report variables and functions: this is not possible in SSRS over AX and results in „unknown identifier” error when building the solution.
- Try to use data methods: I haven’t found a way to access the report context or variables to get the page number.
I have suggested, as a workaround, to either permit the second line to be visible on all pages or move it above the title line, but these solutions are not accepted.
Does anyone have any idea to solve this?
