Adding custom filters to the request form?

pferreira_cai

So I have a report that generates a column "Qty. Available" and would like to create a custom filter that filters a range of the amount in that column. Not really sure where to start. Can anyone help?

Kishorm

1. Create 2 decimal variables to store the minimum/maximum that you want to filter on
2. Add the Decimal variables to the Request page
3. In the OnAfterGetRecord trigger of the DataItem add some code similar to...

IF ("Qty. Available" < Minimum) OR ("Qty. Available" > Maximum) THEN
  CurrReport.SKIP;