2 Replies Latest reply on Jun 26, 2009 3:54 PM by WillGonz

    Filter reports based on results.



      Filter reports based on results.


      I am using the inventory template in FileMaker Pro 10.  I created a report to list out all the items and their counts and reorder level.  I want to filter the results to only show what items need to be reordered.

      I tried to use this in the script If [Inventory::Amount_In_Stock < Inventory::Reorder_Level]  but I know I am not doing it correctly.  How do I tell the report to show only the ones below the reorder level.