Report with 8 data items - sections missing on preview/print

emulsified
Member Posts: 139
I have a report with 8 dataitems.
The report in total has 50 sections.
Value Entry, Header (1)
Value Entry, Header (2)
Value Entry, Header (3)
Value Entry, Header (4)
Value Entry, Body (5)
Value Entry, GroupFooter (6)
Value Entry, Footer (7)
Value Entry2, Header (1)
Value Entry2, Header (2)
Value Entry2, Header (3)
Value Entry2, Body (4)
Value Entry2, GroupFooter (5)
Value Entry2, Footer (6)
Value Entry3, Header (1)
Value Entry3, Header (2)
Value Entry3, Header (3)
Value Entry3, Body (4)
Value Entry3, GroupFooter (5)
Value Entry3, Footer (6)
Value Entry4, Header (1)
Value Entry4, Header (2)
Value Entry4, Header (3)
Value Entry4, Body (4)
Value Entry4, GroupFooter (5)
Value Entry4, Footer (6)
Value Entry5, Header (1)
Value Entry5, Header (2)
Value Entry5, Header (3)
Value Entry5, Body (4)
Value Entry5, GroupFooter (5)
Value Entry5, Footer (6)
Value Entry6, Header (1)
Value Entry6, Header (2)
Value Entry6, Header (3)
Value Entry6, Body (4)
Value Entry6, GroupFooter (5)
Value Entry6, Footer (6)
Value Entry7, Header (1)
Value Entry7, Header (2)
Value Entry7, Header (3)
Value Entry7, Body (4)
Value Entry7, GroupFooter (5)
Value Entry7, Footer (6)
Value Entry8, Header (1)
Value Entry8, Header (2)
Value Entry8, Header (3)
Value Entry8, Body (4)
Value Entry8, GroupFooter (5)
Value Entry8, Footer (6)
Value Entry8, Footer (7)
These sections are not printing:
Value Entry8, Header (1)
Value Entry8, Header (2)
Value Entry8, Header (3)
Value Entry8, Body (4)
Value Entry8, GroupFooter (5)
Value Entry8, Footer (6)
Value Entry8, Footer (7)
It's not any of the properties for the section because they match all of the printing sections section per section, property per property.
Anyone have any ideas?
The report in total has 50 sections.
Value Entry, Header (1)
Value Entry, Header (2)
Value Entry, Header (3)
Value Entry, Header (4)
Value Entry, Body (5)
Value Entry, GroupFooter (6)
Value Entry, Footer (7)
Value Entry2, Header (1)
Value Entry2, Header (2)
Value Entry2, Header (3)
Value Entry2, Body (4)
Value Entry2, GroupFooter (5)
Value Entry2, Footer (6)
Value Entry3, Header (1)
Value Entry3, Header (2)
Value Entry3, Header (3)
Value Entry3, Body (4)
Value Entry3, GroupFooter (5)
Value Entry3, Footer (6)
Value Entry4, Header (1)
Value Entry4, Header (2)
Value Entry4, Header (3)
Value Entry4, Body (4)
Value Entry4, GroupFooter (5)
Value Entry4, Footer (6)
Value Entry5, Header (1)
Value Entry5, Header (2)
Value Entry5, Header (3)
Value Entry5, Body (4)
Value Entry5, GroupFooter (5)
Value Entry5, Footer (6)
Value Entry6, Header (1)
Value Entry6, Header (2)
Value Entry6, Header (3)
Value Entry6, Body (4)
Value Entry6, GroupFooter (5)
Value Entry6, Footer (6)
Value Entry7, Header (1)
Value Entry7, Header (2)
Value Entry7, Header (3)
Value Entry7, Body (4)
Value Entry7, GroupFooter (5)
Value Entry7, Footer (6)
Value Entry8, Header (1)
Value Entry8, Header (2)
Value Entry8, Header (3)
Value Entry8, Body (4)
Value Entry8, GroupFooter (5)
Value Entry8, Footer (6)
Value Entry8, Footer (7)
These sections are not printing:
Value Entry8, Header (1)
Value Entry8, Header (2)
Value Entry8, Header (3)
Value Entry8, Body (4)
Value Entry8, GroupFooter (5)
Value Entry8, Footer (6)
Value Entry8, Footer (7)
It's not any of the properties for the section because they match all of the printing sections section per section, property per property.
Anyone have any ideas?
Half-empy or half-full how do you view your database?
Thanks.
Thanks.
0
Answers
-
How about code in sections / triggers? Indentation? Sorting? Filters?
It's really hard to guess without more information.0 -
Yes, there is code in sections but no CurrReport.SKIP; or SHOWOUTPUT(FALSE); anywhere they shouldn't be no calls to any codeunits or anything.
I originally had 5 dataitems and the report was just fine. I added 3 more dataitems and only the last section I mentioned doesn't output.
Is it possible the report is too large? This is NAV 4.0 SP3 by the way. I would post the code but it has proprietary information in it so I'm not permitted to do so.Half-empy or half-full how do you view your database?
Thanks.0 -
this Should not be the case. I had a report with almost 100 sections and it is running fine. Only thing is each section has only one row and that too are conditioned based.
Check the DataItem properties like PrintOnlyIfDetail, MaxIteration etc. Is the last dataitem is indented to some other dataitem. If yes, may be you can check DataItemLink property again or the filters in OnPreDataItem trigger of last dataitem. Dry run it and Check whether you are sure to get some data with the applied filters.0 -
This is strange, a first for me.
I added another dataitem after the one that wasn't showing up on the output. I copied sections and code from the one that wouldn't show up and mirrored it into the new dataitem/sections.
I saved the report, went back into the report and deleted the dataitem/section that wasn't showing up and then saved the report again.
I ran the report and now the section is showing up without a problem.
Could the report have been messed up somehow? Strange. I guess I'll call this solved. Thanks for your help.Half-empy or half-full how do you view your database?
Thanks.0
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