Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Repeat the Rectangle in each page in SSRS

(0) ShareShare
ReportReport
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

*This post is locked for comments

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans