Announcements
I have rectangle in the body section of SSRS Report that contain tablix and two text box.
by default the rectangle is displaying in the first page only. so i want display it in all page.
Anyone have any idea how to display static data in the body in each page. Thanks
*This post is locked for comments
in such case, you can try by replacing your rectangle with a tablix(table) control
Hi Sohaib, In the body section i have a tablix and two text box that i want repeat it in all page(this is a static data that i can't create in footer).In the footer we can't create tablix
Thanks
Hi Alex,
It is not possible to use Page number in body section of report. This is restriction on AX-SSRS.
To achieve your requirement may I suggest to Place your rectangle in Header or Footer of report. A rectangle added in body can repeat only once. To repeat rows in body usually a Table control is used. If you can add few more details about your rectangle, we can speak more on it. But generally speaking if you want to repeat something on each page, Header and/or Footer are correct places.
Thanks for the quick reply , this solution not work , i get this error
The Visibility.Hidden expression for the rectangle ‘rectangle1’ refers to the global variable PageNumber or TotalPages. These global variables can be used only in the page header and page footer.
in the properties of the rectangle, in visibility, choose to display or hide based on an expression you click on the fx button and place the following
=IIF(Globals!PageNumber=Globals!TotalPages,true,true)
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156