Why integer report skips first record

johnnyp
Member Posts: 14
Helo,
I'm not a developer but an administrator, so i hope this isn't a totaly dumb question
I made a report with 2 Integer data items. In the first dataitem i filled a temporary table with data. With the second line i wanted to print out that temporary table.
In OnPreDataItem i added a range, so it wouldn't loop indefinitely (SETRANGE(Number,1,tDim.COUNT)).
In Sections-Body, OnPostSection i added tdim.NEXT so it would print next record.
It all works fine it just doesn't print out the first record of my temporary table and repeats the last record.
If anyone has an idea why this works the way it does I would really appreciate the help.
Johnny
I'm not a developer but an administrator, so i hope this isn't a totaly dumb question

I made a report with 2 Integer data items. In the first dataitem i filled a temporary table with data. With the second line i wanted to print out that temporary table.
In OnPreDataItem i added a range, so it wouldn't loop indefinitely (SETRANGE(Number,1,tDim.COUNT)).
In Sections-Body, OnPostSection i added tdim.NEXT so it would print next record.
It all works fine it just doesn't print out the first record of my temporary table and repeats the last record.
If anyone has an idea why this works the way it does I would really appreciate the help.
Johnny
0
Best Answer
-
check report 122 how this works.5
Answers
-
check report 122 how this works.5
-
Thank you, i found just what i needed in that report.0
-
Because in the first loop you didn't have a record. Only after the loop finishes, you do a NEXT.
The sections should ONLY be used for deciding or not to show a section.
All other code should be in the OnAfterRecord-trigger:
IF Number = 1 THEN
tdim.FINDFIRST
else
tdim.NEXT;
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!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