Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Repeat the Rectangle in each page in SSRS

Posted on by 910

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

  • sohaibcheema Profile Picture
    sohaibcheema 46,600 User Group Leader on at
    RE: Repeat the Rectangle in each page in SSRS

    in such case, you can try by replacing your rectangle with a tablix(table) control

    social.msdn.microsoft.com/.../repeat-rectangle-on-each-page

    forums.asp.net/.../1347596.aspx

  • ALAhmed Profile Picture
    ALAhmed 910 on at
    RE: Repeat the Rectangle in each page in SSRS

    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

  • sohaibcheema Profile Picture
    sohaibcheema 46,600 User Group Leader on at
    RE: Repeat the Rectangle in each page in SSRS

    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.

  • ALAhmed Profile Picture
    ALAhmed 910 on at
    RE: Repeat the Rectangle in each page in SSRS

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Repeat the Rectangle in each page in SSRS

    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)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans