how do i accomplish this ?
spiral
Member Posts: 12
hi, i got a problem i had a report dealing with sales header and sales invoice line. i did the relationship data model but the user wants the first record of the sales line displaying only the "description" field after the sales header details are shown. how do i accomplish this?
0
Comments
-
I did a simular thing for the reminders report. I don't know if you are familiar with the report designer.
You have to add an integer loop, before the sales invoice line loop. In this integer loop, you can go through the sales invoice lines. The first line should be printed (you have a separate section for this loop), for the other lines, use the SHOWOUTPUT(FALSE) statement to skip these lines.
In the exisiting sales invoice line loop, you do the opposite.
You might need some reporting experience to accomplish this.0
Categories
- All Categories
- 75 General
- 75 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions