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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

SSRS report create extra page after exporting to PDF

(0) ShareShare
ReportReport
Posted on by 1,559

Hi Friend,

I have a PO report, it looks fine when generating it, but, when exporting it to PDF, somehow it creates extra page.

Report size is absolutely fit into one page. Tried so many things, it just won't help.

Any hint?

Thanks,

River

*This post is locked for comments

I have the same question (0)
  • Denis Macchinetti Profile Picture
    16,444 on at

    Hi Ganriver

    About this behaviour, I suggest you to read the follow post :

    community.dynamics.com/.../158684.aspx

    community.dynamics.com/.../217931.aspx

    Here you can found more info about your issue.

  • Community Member Profile Picture
    on at

    Consider verifying the Report footer it you have any control with fixed width.

  • Ganriver1 Profile Picture
    1,559 on at

    I don't have footer.

    Thanks.

  • Ganriver1 Profile Picture
    1,559 on at

    Thanks, checked all that.

    Still same problem.

  • Hanny_Gaoxing Profile Picture
    520 on at

    Make sure your report size in your report properties can handle all text in report (including header and footer must be counted when you set report size).

  • Suggested answer
    Deepak Agarwal Profile Picture
    8,598 on at

    can you please re-verify the length-width of each and every section and make sure it will not exceed the total length of A4 page size.

  • Community Member Profile Picture
    on at

    during making srs report in visual studio. insert footer on design page.

    if you have data for footer put inside the footer or blank it.

    make sure footer has small size

    deploy and check

    please if it is proper solution.let me know.

    thanks

    kundan

  • Ganriver1 Profile Picture
    1,559 on at

    Tried everything suggested here, still same problem. I would shelf it for now, come back later.

  • Suggested answer
    venkatesh vadlamani Profile Picture
    3,180 on at

    make sure the design is absolutely having no blank space below all rendering controls.Even blank space is considered a static space to be rendered, so the report even though finishes in a page will render this blank space you might have left out.

    Check for you report width in similar fashion

    Now check for report sizes including margins. if you report paper size is A4 check for A4 sizes and dont let the design to be having more than this size.

    Interactive sizes should be accordingly set.

    If these are taken care of , i don't see anything else causing problems

  • Suggested answer
    Ismael Utitiaj Profile Picture
    426 on at

    It's a common issues into SSRS report when exporting to PDF. I suggest you to change the marge, into Visual Studio section body design  click Rerport - Report properties menu, set Left and Right Margins to 0.00, Paper size A4, Width 21 cm Height 29.7 cm and in the body section set the properties Size to Width 20.cm

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…

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