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
  • I've inserted the following in the OnPreDataItem trigger and my report still shows items with values.

    My Boolean on the request form is "Show0Values"


    IF Show0Values THEN BEGIN
    IF InventoryValue <> 0 THEN
    CurrReport.SKIP
    END;
Children
No Data
Related
Recommended