Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Placing some fields on the last page of SSRS report

(0) ShareShare
ReportReport
Posted on by

Hi Guys,

Below is my SSRS report design, I want Total Amount, Customer Signature on the last page of the report. As Product and Service Lines are dynamic, sometimes they span to the multiple pages but Total Amount, Customer Signature are on first page of the report. Can you tell me how make sure that Total Amount and Customer Signature are on Last Page?

6215.report.JPG

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Placing some fields on the last page of SSRS report

    Hello.

    Footer will not support exp. In ms word so I will also go with Abby's answer

    Please try this

  • Suggested answer
    Abby Kong Profile Picture
    6 on at
    RE: Placing some fields on the last page of SSRS report

    As Aric suggested, report footer works. With this approach, contents would be displayed together at footer position. If footer on every page is not desired. Try wrap both boxes in a rectangle, and set keep contents together: 

    1. Insert a rectangle, and place it at the bottom of the report

    2. Adjust rectangle size and move Total Amount and Customer Signature inside the rectangle

    3. Right click on the rectangle to open Rectangle Properties. Tick 'Keep contents together on a single page, if possible'.

    Make sure the rectangle is placed at the bottom of SSRS report, total amount and Customer Signature will be displayed at any position based on content length on the last page.

    KeepContentTogether.png

  • Aric Levin - MVP Profile Picture
    30,188 Moderator on at
    RE: Placing some fields on the last page of SSRS report

    Add them to the Report Footer. The report footer will always display on the last page of the report. The page footer will display on every page.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
Victor Onyebuchi Profile Picture

Victor Onyebuchi 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans