mibuso.com
Home› Navision Financials
Options

Filter report Zone wise for Option Datatype.

rranjanerprranjanerp Member Posts: 70
edited 2013-11-26 in Navision Financials
Dear experts,

I am trying to filter my report zone wise with options of north,east,west..My Report is based on ILE. I accessed zone from customer table..

IF Cust.GET("Customer No.") THEN BEGIN

Name := Cust.Name;

Zone1 := Cust.Zone;

END;

its easily displayed on the report but i could not find the way to filter my report zone wise .I used many formats available on net for SETFILTER.like

ILE.SETFILTER(Cust.Zone,'%1',Cust.Zone::North); i also tried by making zone a primary key in cust table.Field id of zone in ILE is different than Customer table.plz guide ..


Thanks.

Comments

  • Options
    KishormKishorm Member Posts: 921
    You can't filter on the Cust variable like that but what you can do is add the following piece of code...

    IF Cust.Zone <> Cust.Zone::North THEN
    CurrReport.SKIP;

    ...which should achieve what you want.
  • Options
    AlbertvhAlbertvh Member Posts: 516
    Field id of zone in ILE is different than Customer table.

    This won't matter if the fields are both an Option type and also have the same options
    your filter setting should be something like this
    ILE.SETFILTER(Zone,'%1',Cust.Zone);
or
ILE.SETRANGE(Zone,Cust.Zone);

    Hope this helps
Sign In or Register to comment.