web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Shrinking the empty fo...
Microsoft Dynamics AX (Archived)

Shrinking the empty footer space in SSRS

(0) ShareShare
ReportReport
Posted on by Abhinay Tharwal 1,215

Hi,

I control the visibility of the footer of my SSRS report using the following statement:

iif(Globals!PageNumber = Globals!TotalPages, false, true)


which works just fine. But, for the pages where footer is set hidden, a blank space appears in the output.

I want to suppress that space and utilize it.

Does anyone know how to achieve that?

Regards,

Abhinay

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    faheem Ahmed Profile Picture
    faheem Ahmed 450 on at

    I think what you are trying to do is print footer on last page and not to display anything as long as your body has data.

    If so just place the footer in the body after your table. Once your data is finish system will display footer.

  • Abhinay Tharwal Profile Picture
    Abhinay Tharwal 1,215 on at

    That's not a good news...

    Thanks for your reply.

  • Abhinay Tharwal Profile Picture
    Abhinay Tharwal 1,215 on at

    The issue with this approach is that the footer values do not stick to the bottom of the report and may elevate to the top of the last page.

  • faheem Ahmed Profile Picture
    faheem Ahmed 450 on at

    You can add empty space between table and footer depending upon your page size. It will sit at bottom if you adjust it right.

    Then again it’s just a work around you might say it is at bottom but not fixed.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans