Report with fixed sales invoice lines
Kate10
Member Posts: 4
Hi all!
I am new to Navision and I have some problems creating a report.
I am making a sales invoice report with these DataItems:
DataItem Name
Sales Invoice Header <Sales Invoice Header>
No. Series <No. Series>
Integer CopyLoop
Integer PageLoop
Sales Shipment Header <Sales Shipment Header>
Integer DimensionLoop1
Sales Invoice Line <Sales Invoice Line>
Integer DimensionLoop2
Integer BlankLine
Integer VATCounter
Integer Total
Integer Total2
The sections are these:

The report looks like this:
What I need is the Description to be fixed. For example it should contain max 20 records (items) and If I have more (for example 30), they should be printed in the second page. In the second page the Description section should be exactly the same.
Or if I have just one item in this report, the Description section should have the same shape.
I am a rookie in programming with navision, so please be very analytic. Thanks!
I am new to Navision and I have some problems creating a report.
I am making a sales invoice report with these DataItems:
DataItem Name
Sales Invoice Header <Sales Invoice Header>
No. Series <No. Series>
Integer CopyLoop
Integer PageLoop
Sales Shipment Header <Sales Shipment Header>
Integer DimensionLoop1
Sales Invoice Line <Sales Invoice Line>
Integer DimensionLoop2
Integer BlankLine
Integer VATCounter
Integer Total
Integer Total2
The sections are these:

The report looks like this:

What I need is the Description to be fixed. For example it should contain max 20 records (items) and If I have more (for example 30), they should be printed in the second page. In the second page the Description section should be exactly the same.
Or if I have just one item in this report, the Description section should have the same shape.
I am a rookie in programming with navision, so please be very analytic. Thanks!
0
Answers
-
Did you try adding to the code On SalesInvoiceLineBody(2) section
OnPostSection()
LinesPerPage := LinesPerPage + 1;
IF LinesPerPage > 20 THEN
CurrReport.NEWPAGE;0 -
If I do this (for example a report with 30 records(items)), it brings 20 records in the first page and the other 10 in the second but if i have a report with 1 record the shape of the Decription section changes and becomes smaller in order to contain only this one record.
What I need is the shape of the Description section to remain the same on every page regardless of the records that contains.
Thanks though, we are one step closer now.
0 -
-
Thanks a lot for your help. I think I found it!
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 333 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