Filter code

mar

Hi,
I want to set a filter to select only fields with less than 2 char.
I want to do a report that only shows accounts ( from Chart of Accounts) with 2 numbers. ( this field is a code)
Does anyone know how can i do it?

Thanks

Albertvh

You could try

SETFILTER("No.",'?');

Albert

Nagi

IF STRLEN("No.") > 2 THEN
  CurrReport.SKIP;

Put this in the OnAfterGetRecord trigger. Should work fine, but the downside is that the report has to run through all the records.

mar

it's working!

thanks you both!