Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / How to avoid extra bla...
Finance forum

How to avoid extra blank page in SSRS Report?

(0) ShareShare
ReportReport
Posted on by 952

Hi 

I created a report and created a table with layout like this.

54.png

My situation is that I have a record, which has multiple items. Then when I print report to PDF, the first page is blank, all records show up on the second page. Such as like this.

52.png

53.png

How could I set up report to avoid this situation.

Best Regards,

JustZM

  • D365 Developer Profile Picture
    D365 Developer 215 on at
    RE: How to avoid extra blank page in SSRS Report?

    In addition to the Repeat header property you will need to enter the groups Advanced Mode:

    You can access to groups Advanced Mode by clicking on the little black arrow on the right hand side.

    Once the Advanced Mode has been selected (this is a toggle action) the grouping pane will open up

    To complete the configuration for repeated column headings you need to left click on the “Static” row that represents the group scope the headings belong to.

    With the relevant Static group selected you will see that the Properties Window on the right hand side reflects the properties for this object l

    Locate the property called RepeatOnNewPage and set this to True

    The column Headings for the table will now be repeated across all pages.

  • JustZM Profile Picture
    JustZM 952 on at
    RE: How to avoid extra blank page in SSRS Report?

    Hi D365

             I added this table in Report body, so the Header is part of report body.

    55.png

    Best Regards,

    JustZM

  • D365 Developer Profile Picture
    D365 Developer 215 on at
    RE: How to avoid extra blank page in SSRS Report?

    Check if the header is part of report header or report body.

  • JustZM Profile Picture
    JustZM 952 on at
    RE: How to avoid extra blank page in SSRS Report?

    Hi All

              My report and table's width is only 6.5, I think that is ok.

             I found some information from online. I guess my problem is caused by "KeepTogether". When I set last 4 rows in Table "KeepTogether" to false, it solved my problem, however, the header row does not repeat even if I checked "Repeat header rows each page".

    Have any idea to fix this issue?

    Best Regards,

    JustZM

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,656 Moderator on at
    RE: How to avoid extra blank page in SSRS Report?

    See if guidelines from below link helps you

    stoneridgesoftware.com/blank-page-issues-ssrs-reports

  • D365 Developer Profile Picture
    D365 Developer 215 on at
    RE: How to avoid extra blank page in SSRS Report?

    Check the size of tables in the design. May be the width of them is greater than the pdf page size.

  • JustZM Profile Picture
    JustZM 952 on at
    RE: How to avoid extra blank page in SSRS Report?

    By the way, I copy this table from exist report "SalesPackingSlip"

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans