question

Zolotoy-3922 avatar image
0 Votes"
Zolotoy-3922 asked Joyzhao-MSFT commented

SSRS report footer with variable height

I am showing some items in the footer conditionally. I want to have footer changing its height accordingly. Is that possible?

Thanks

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @Zolotoy-3922 ,
When there are text boxes in the footer, make sure the CanGrow property of the text box is set to "True" ,"Allow heigh to increase" and "Allow heigh to decrease" are checked in the Text box Properties, The footer height will follow the height of the text box.

In hard page break rendering formats like PDF, the height of page header/footer is fixed. Besides, it not supported to set the height of the page header/footer based on an expression currently. This is by design.

Hope this helps.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

So, in PDF version the footer keeps the height, right?

0 Votes 0 ·

PDF belongs to Hard page-break rendering extensions.
Hard page-break renderer extensions maintain the report layout and formatting. The resulting file is optimized for a consistent printing experience, or to view the report online in a book format. So the height is fixed.


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 Votes 0 ·