Report Boolean to filter zero value

I've added a Boolean to the Request Form in the "Inventory to G/L Reconcile" report. When the Boolean is checked, I would like the report to display only items with a zero "Inventory Value". The InventoryValue field is an existing calced field on the report.

I can't seem to code this properly and the Boolean doesn't filter when checked. It should filter on 0 Inventory Values, but I cant get it to work. Any ideas?
Parents
No Data
Reply
  • Your code in your OnAfterGetRecord - Trigger should look like this:


    IF Show0Values THEN BEGIN
    CALCFIELDS(InventoryValue);
    IF InventoryValue <> 0 THEN
    CurrReport.SKIP;
    END;


    if your InventoryValue is a flowfield.

    if it is not, please tell me how you determine the InventoryValue
Children
No Data
Related
Recommended