Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

blank page at end of report

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I'm doing a report using Visual Studio.When exporting to word, at end of report appears blank page. How to remove it?

*This post is locked for comments

  • CristianAguerre Profile Picture
    CristianAguerre 145 on at
    RE: blank page at end of report

    Hi Vesna,

    First, The printOnly detail is for this:

    Example: 

    Sales Header table and Sales Line table

    You have a order (order 1) with lines and other order (order 2) without lines.

    If in a report you create a dataitem with Sales Header and second dataitem Sales Line and link Sales Line to Sales Header. If you mark yes the print only datail option (if you create layour with correct groups) the report only show the order have lines.

    Second, 

    Some times the standart acción to export word not works good... then review if in the report viewer look´s fine your report, if not then:

    1º Check the width of your layour report is correct. Check Not have a blank area in the right. like some this:

     ruler.PNG

    In the picture you can see a area blanck without data (marked with red line bellow), but this area is printed by the report then if more large that page size it creates a second page to put this area. 

    2º Review the height (same before)

    3º When you print the report press cntr + alt + f1 and review the detaill data. Look if you see blanks rows or some data wrong.

    If you see some blank rows then maybe you need create a rule visibility or:

    4º Review your groups defined in the report are correct comparing with the data of point 3.

    If this not work please set some pictures of your dataitem, dataitem properties and layout desing, etc....

    Regards

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,184 on at
    RE: blank page at end of report

    Hi

    Select the Dataitem in the report,

    yes.JPG

    then click on Shift+F4

    yes.JPG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: blank page at end of report

    When i choose that option it doesnt show any report data

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,184 on at
    RE: blank page at end of report

    Hi

    Click on Dataitem then select Properties. set PrintOnlyIfDetails to Yes. this will eliminate blank data

    [View:https://msdn.microsoft.com/en-in/library/dd301378.aspx:750:50]

  • Tina Menezes Profile Picture
    Tina Menezes 2,580 on at
    RE: blank page at end of report

    Hi,

    Are you using getData setData in the report header and do you have any hidden textbox which has show or hide expression ? Sometimes the hidden textbox causes a problem and blank space is displayed in the report

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: blank page at end of report

    I checked it. It is ok

  • Suggested answer
    Tina Menezes Profile Picture
    Tina Menezes 2,580 on at
    RE: blank page at end of report

    Hi,

    You need to check the below 2 conditions:

    1. Total Height of (Header+Body+Footer+Top margin+Bottom margin) should be <= Page height

    2. Total width of (Body +Left margin+right margin) should be <= Page width

  • Suggested answer
    Zaid Tariq Profile Picture
    Zaid Tariq 2,270 on at
    RE: blank page at end of report

    Actually you need to calculate the size manually, (Header +Body + Footer)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: blank page at end of report

    How to check layout size?

  • Suggested answer
    Zaid Tariq Profile Picture
    Zaid Tariq 2,270 on at
    RE: blank page at end of report

    Make sure your layout size is not greater the page size.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,289 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans