1)Site Selection

2)Category 1

 

i'm trying to set up the following record selection for each parameter field

IF {?Site Selection} <> '*' THEN
{mp_bdsPOApproveReceiptComparison;1.POSite} = {?Site Selection}
ELSE
{?Site Selection} = '*'

OR
 IF {?Category 1 } <> '*' THEN
{mp_bdsPOApproveReceiptComparison;1.CatCodesCode1} = {?Category 1 }
ELSE
{?Category 1 } = '*'

 

when running the report the IF statement related to {?Category 1} is ignored by the report and all records are returned. Can i create a second record selection to deal with {?Category 1}???

 

thanks for your help