Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Boolean filter on record before report.runmodal
Nagi
Member Posts: 151
Hello NAV experts!
I am trying to set a boolean filter on a field and then call report.runmodal with the record variable. Basically I want a default boolean filter to be true when a report is run. The thing is that NAV doesn't seem to save the boolean filter. Other filters are saved, like if you set filter on a code field, but not if you set filter on a boolean field.
The filters on document type, no. and sell-to customer no. are all present when the report is run, but the filter on my boolean field is lost. Does anybody know why this is so? This is NAV 2013 R2 build # 7.1.37563.0
I am trying to set a boolean filter on a field and then call report.runmodal with the record variable. Basically I want a default boolean filter to be true when a report is run. The thing is that NAV doesn't seem to save the boolean filter. Other filters are saved, like if you set filter on a code field, but not if you set filter on a boolean field.
SalesHeader.SETRANGE("Document Type",SalesHeader."Document Type");
SalesHeader.SETRANGE("No.",SalesHeader."No.");
SalesHeader.SETRANGE("Sell-to Customer No.",SalesHeader."Sell-to Customer No:");
SalesHeader.SETRANGE("My Boolean Field",TRUE);
REPORT.RUNMODAL("My Report ID",GUIALLOWED,FALSE,SalesHeader);
The filters on document type, no. and sell-to customer no. are all present when the report is run, but the filter on my boolean field is lost. Does anybody know why this is so? This is NAV 2013 R2 build # 7.1.37563.0
0
Comments
Maybe you should change it to:
SalesHeader2.SETRANGE("Document Type",SalesHeader."Document Type"); SalesHeader2.SETRANGE("No.",SalesHeader."No."); SalesHeader2.SETRANGE("Sell-to Customer No.",SalesHeader."Sell-to Customer No:"); SalesHeader2.SETRANGE("My Boolean Field",TRUE); REPORT.RUNMODAL("My Report ID",GUIALLOWED,FALSE,SalesHeader2);Tino Ruijs
Microsoft Dynamics NAV specialist