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.
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
Comments
Maybe you should change it to:
Tino Ruijs
Microsoft Dynamics NAV specialist