Placing some fields on the last page of SSRS report

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Abby Kong 6 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello.

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

Please try this

Was this reply helpful? Yes No