Skip to Content
0
Former Member
Jan 26, 2011 at 08:07 PM

Selection expert

20 Views

I'm trying to use this formula...

({mrexpfil_sql.gen_file} = "0" and

{mrexpfil_sql.ord_type} in ["CP", "PO"] and

{iminvloc_sql.loc} = "PH1" and

{mrexpfil_sql.item_no} = "96-031" and

{mrexpfil_sql.except_tp_j} = "J") OR

({mrexpfil_sql.gen_file} = "0" and

{mrexpfil_sql.ord_type} in ["CP", "PO"] and

{iminvloc_sql.loc} = "PH1" and

{mrexpfil_sql.item_no} = "96-031" and {mrexpfil_sql.except_tp_b} = "B")

...to get data in from two different fields to display in the report. When I run the report the only the first criteria is reported back. Any ideas?