Report Line Count

clippernet
Member Posts: 38
Hello forum,
I have a problem with the reports in Navision, they all seem to generate page breaks by some hidden algorithm that assumes less lines than there are in reality. When the sales quote for instance has two or more items (with extended texts), then the report breaks into 2 pages. However, the second part would easily fit onto the first page.
I haven't made any changes at all to the standard reports, however I can't get the bottom third of the first page to be used up fully.
Now I read somewhere in this forum that there was an unseen maximum of 45 lines for reports, is that true? And if so, is there a way to change this to - say - 55?
Thanks in advance
Beo
I have a problem with the reports in Navision, they all seem to generate page breaks by some hidden algorithm that assumes less lines than there are in reality. When the sales quote for instance has two or more items (with extended texts), then the report breaks into 2 pages. However, the second part would easily fit onto the first page.
I haven't made any changes at all to the standard reports, however I can't get the bottom third of the first page to be used up fully.
Now I read somewhere in this forum that there was an unseen maximum of 45 lines for reports, is that true? And if so, is there a way to change this to - say - 55?
Thanks in advance
Beo
0
Comments
-
You have to play with the margins of the report to get the number of lines you want. Navision uses 1mm as the base unit of measure. You probably need to break out the ruler to get the exact lines you want.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Thanks for the reply, you are right, I can gain some space by setting the bottom margin to 0. However there is still loads of free space on the first page, and the second page contains just three lines. It doesn't seem possible to set negative values here.
One other thing that I've noticed is that when I reduce the paper size, I get less rows and the preview page adjusts as expected. However, when I increase the paper size to - say - A3, then _nothing_ changes. The preview looks exactly the same size with the same amount of line as when the paper size is A4.
Maybe I'm looking at the wrong place, because the default value in the bottom margin of the report's properties was 2000 (which couldn't possibly be 2000 mm ?) Is there some global setting maybe?
Thanks in advance,
Beo0 -
Hello again,
I've been doing some debugging and I've found out that the reason for the free space is because there are sections on the report that - while being invisible via CurrReport.SHOWOUTPUT - nevertheless use up space.
How can I ensure that sections that are invisible don't add with the calculation of the available linecount? Which is frankly what I would have expected in the first place?
Thanks in advance
Beo0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions