Automatic SETRANGE by user Selection
BobBreton
Member Posts: 7
I would like to use the Highlighted selection in Table view to SETRANGE on a filter. ie. When viewing the Invoice List, the user selects the first 5 records, I would like to batch print these records by SETRANGE. Is it possible to get this range that is selected, Every time I use REC it returns the First selected item, ignoring the others. I would even like to see a selection of 5 random records sent as a setrange. Is this possible?
RKB
0
Comments
-
Hi,
Yes, it is possible.
Use the CurrForm.SETSELECTIONFILTER(Rec) function to store the selected records on the Form in the Record variable of your choice.
Try it!Nelson Alberto0 -
CurrForm.SETSELECTIONFILTER(Rec);
REPORT.RUNMODAL(50001, FALSE, FALSE, Rec);
Why does this not work?RKB0 -
Using that code I think you need to get up from your chair and go check the printer.

If you call the REPORT.RUNMODAL with FALSE in the 2nd parameter, it will completely bypass the Request Form and you will have no chance to even see the Report before it is sent to the Printer.
Try:CurrForm.SETSELECTIONFILTER(Rec); REPORT.RUNMODAL(50001,TRUE,FALSE,Rec);
Nelson Alberto0 -
Thanks, I had another issue... Works Fantastic!RKB0
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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 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