report prints on 2 pages instead of one
yekede
Member Posts: 96
Hi everyone,
I have designed a report with 'friend'(an exemple) as first dataitem, 'guests' as the second dataitem indented under 'friends', and 'friend1' as another dataitem(same table as 'friend') indented under 'friend'. This report should loop through 'friend' table then print all 'guest' corresponding to that 'friend' and at the end print some more information from the 'friend' table.
this is the problem i encounter:
when the 'friend' table contain exactly one record the report prints well and on a single page.
But when the 'friend' table contain more than one record the report print on 2 pages for each record and repeats the information from 'friend1' dataitem on the second page.
any idea how i can deal with this?
Thanks.
I have designed a report with 'friend'(an exemple) as first dataitem, 'guests' as the second dataitem indented under 'friends', and 'friend1' as another dataitem(same table as 'friend') indented under 'friend'. This report should loop through 'friend' table then print all 'guest' corresponding to that 'friend' and at the end print some more information from the 'friend' table.
this is the problem i encounter:
when the 'friend' table contain exactly one record the report prints well and on a single page.
But when the 'friend' table contain more than one record the report print on 2 pages for each record and repeats the information from 'friend1' dataitem on the second page.
any idea how i can deal with this?
Thanks.
0
Answers
-
not a very clear post - plus we don't know what kind of code you have added to the report.
but first check that the properties for these dataitems "NewPagePerRecord" and/or "NewPagePerGroup" is set to NO.
or are you talking about everything working but you're getting an extra page at the end?0 -
i mean the part of the the report containing data from 'friend1' table prints x number of times(x= number of records in 'friend' table)
I have solved it now by setting the 'dataitemlink' property of the 'friend1' dataitem.
Thanks0
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