Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

blank page at end of report

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,576 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,576 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,266 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,266 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans