two selection params sometimes one

[stevesd]

I am asked to select records based on two parameters {type} and {subtype}. But I can't always choose based on both. sometimes I have to use just {type}, i.e. if {type} ="CR" then I want all {subtype} but if {type}= "EF", then {subtype} must be "FI" or "FO" only. there are other conditions such as if {type} = "JN" then {subtype} must be "WT". I need to chose {type} and {subtype} sometimes but not always. Question: would it be easier to use lots of parameters or just start making if, then statements in the record selection formula?

 

[synapsevampire]

Since parameters aren't dynamic, nor do they interact, I would do this only within the record selection formula, you're going to have to do it there anyway.

It sounds like subtype is never really chosen, it's based on the type, so it shouldn't be a parm at all.

-k