Filter code

mar
mar Member Posts: 17
edited 2008-09-18 in NAV/Navision Classic Client
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

Comments

  • Albertvh
    Albertvh Member Posts: 516
    You could try
    SETFILTER("No.",'?');

    Albert
  • Nagi
    Nagi Member Posts: 151 
    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
    mar Member Posts: 17
    it's working!

    thanks you both!

Categories