Filter report Zone wise for Option Datatype.

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.

Hey use the zone field of ile and the customer zone

something like below.

ile.setfilter(ile.zone,’%1’,cust.zone::north);

Hi

Is ZONE is your dimension or FIeld in any table?

Is it attached to Customer Table ???

Zone is a customized field of Customer table. ILE table on which my report is based does not have zone field.