Finance | Project Operations, Human Resources, ...

SSRS Footer in last page

(1) Share

Report

Posted on by Jesús García

619

Hello everyone, I've been working on a form development case for a few days now and I'm having a hard time with it.
It turns out that I need that for a form, the sales order form in this case, only the footer is shown on the last page. Following these guidelines, I simply added an expression to the Hide property of the rectangle containing the items inside the footer to hide them on all pages except the last one. However, the form still reserves this space on the rest of the pages and I have blank spaces that are not being wasted.
As an alternative, and following several forums and information on the internet, what I did was to remove the footer and add the information it contained in a rectangle at the end of the body, with its respective expression in the hide property so that it is only shown at the end of the ssrs. The blank spaces are no longer a problem, but now this ‘footer’ does not appear fixed at the end of the page. Is there any way to do this? I have tried changing the position of the footer rectangle but as it is not fixed, the position is different every time I view a different report. I hope you can help me with this problem.

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Olayinka Komolafe 29 on at

Like
a
(2)

Report
Copy link

Link copied!

Have you tried using a footer and in the "footer" properties, uncheck the property "Show on first page" and check the property "Show on last page".

Did you do this and it still didn't work?

Was this reply helpful? Yes No
Jesús García 619 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Olayinka,

Yes, i've tried with with the configuration you said but it didn't work, footer shows in all pages except the first one, and in this it keeps the whitespace.

Was this reply helpful? Yes No
Suggested answer

Sankar Ramalingam 262 on at

Like
a
(0)

Report
Copy link

Link copied!

If you don't want to show in all pages then you shouldn't add to footer section instead add at the end of the Body section. This may match with your requirement.

Was this reply helpful? Yes No
Jesús García 619 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sankar, yes this was one of the alternatives i did, but it apperars another problem: The footer is only in the last page but i cant fix it in the end of page, is immediately after the last data, and a i need to put at the end

Was this reply helpful? Yes No
Suggested answer

Sankar Ramalingam 262 on at

Like
a
(0)

Report
Copy link

Link copied!

You can calculate the page height and position the location to end of the page.

If its Letter page format, then it is 8.5 x 11 inches

and incase top and button margin collectively 2 inches then remaining 9 inches for report body. Extend the report body to 9 inches and place the footer text there.

* If this answer you question, mark this comment as answered

Was this reply helpful? Yes No