Mulitple "All" Parameter selection criteria question 1

[redsand23]

I am running cr9.2 and am having difficulty with multiple paramter selection criteria
The goal is to have the user have the ability to choose any combination (Both all/none all/1 all 1 value)

{QryRep.ReqDate} in {?StartDate} to {?EndDate} and
IF {?Cellname} <> "All" then {QryRep.Cellname} = {?Cellname} else true and
IF {?ProductType} <> "All" then {QryRep.tblMain.Prodtype} = {?ProductType} else true

Can someone help with the order of how 2 "All" selection criteria works

Thanks!!

 

[DuncanSutcliffe]

It's all in the parentheses:

{QryRep.ReqDate} in {?StartDate} to {?EndDate} and
(IF {?Cellname} <> "All" then {QryRep.Cellname} = {?Cellname} else true) and
(IF {?ProductType} <> "All" then {QryRep.tblMain.Prodtype} = {?ProductType} else true)

Should do the trick.

Duncan

 

[redsand23]

Thanks that works great