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
-
Probably has something to do with the use of two times Salesheader.
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 specialist0 -
Hello and thank you for your reply.
I should specify that the record SalesHeader has values, so using those values to set filter on the fields should be ok. My modification is to codeunit 229 and function PrintSalesOrder. I have tried changing it to SalesHeader2, but the result is the same. I'm suspecting that this is a bug in 2013 r2 ](*,) ](*,) ](*,)
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