Report with multiple dataitems

ramsay18477
Member Posts: 52
Hi,
Iam designing a report with multiple dataitems which are not linked to each other with the intention of processing only the dataitem that the user chooses.
But, the report always processes the first dataitem even though I've chosen the second one and I've written a check to 'EXIT' if that dataitem is not chosen. It always goes into the section of the unchosen dataitem, exits because of the check, then goes into the 'On after get record', again exits because of the check and repeats the process continuously. I think goes into a loop for the number of records in that dataitem and processes for each record.
I would like to know if there is a way by which only the dataitem that is chosen is processed and all others are excluded.
Thanks.
Iam designing a report with multiple dataitems which are not linked to each other with the intention of processing only the dataitem that the user chooses.
But, the report always processes the first dataitem even though I've chosen the second one and I've written a check to 'EXIT' if that dataitem is not chosen. It always goes into the section of the unchosen dataitem, exits because of the check, then goes into the 'On after get record', again exits because of the check and repeats the process continuously. I think goes into a loop for the number of records in that dataitem and processes for each record.
I would like to know if there is a way by which only the dataitem that is chosen is processed and all others are excluded.
Thanks.
Thanks & Best Regards,
Ram.
Ram.
0
Answers
-
At a quick thought you should be using CurrReport.BREAK not exit (??)Sleep on it... The best solutions come at 2am0
-
Hi prototyper,
Thanx a lot for your advise.
I tried using 'BREAK' but it still comes back to the pre dataitem where I've written the 'BREAK' in the check.
Actually, the report structure is like this :-
DataItem1
|_ Integer (Under Dataitem1)
DataItem2
The process gets trapped in the triggers of the 'Integer' dataitem, which is under DataItem1, even with the checks whereas it 'EXITS' successfully from DataItem1 because of the check.
Thanks again.Thanks & Best Regards,
Ram.0 -
OK. What link do you have between dataitem 1 and Integer ? do you have "Print only if detail" set on integer ?Sleep on it... The best solutions come at 2am0
-
directly from the help online:BREAK (Dataport, Report, XMLport)
Use this function to exit from a loop or a trigger in a data item trigger of a dataport, report or XMLport.
solution: put currreport.break in onaftergetrecord, too.0 -
Hi Prototyper / Belias,
Thanx again.
No, there are no settings for Integer.
The print only if detail is set to No by default.
Only the Data Item Link is set to 'DataItem1' which is default as it is indented.
Anywayz, I think I've solved it thanks to you guys.
I put the break right at the on pre-data item of DataItem1 so that it doent go further at all.
Thanx a lot again.Thanks & Best Regards,
Ram.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