Post reply

How to resize an SSRS report with a 0 height page footer

  • December 22, 2014 at 7:20 am

    #314015

    I have an SSRS report and instead of removing the page footer, its bottom edge was dragged up to the main body of the report therby giving it 0 height. However I need to modify this report to include a footer but I can't work out how to get into it. Removing the footer and adding it again doesn't work, I can't find a way to access its properties to change its height and although the marker on the ruler is showing the footer division I am unable to drag it up without resizing the whole page.

    Can anyone advise a solution that doesn't involve recreating the report?

    Thanks.

  • December 22, 2014 at 9:00 am

    #1766002

    Back up your RDL before doing this...

    In Visual Studio right-click on the report and select "View Code". In the code you will see a footer section. I'm pretty sure that you can change the height there. Save the file and re-open your report.

    Im not at a pc at the moment otherwise I'd provide an example.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • December 22, 2014 at 9:10 am

    #1766007

    Fantastic suggestion; thanks for that. The footer was set to 0.26458mm high so it's no surprise I couldn't select it!

  • December 22, 2014 at 9:43 am

    #1766022

    No prob. Glad to help. 😎

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply