You can do a formula field that applies different tests based on a parameter, e.g.
Code:
(@Param = "M"
and {your.value} in ["Tom", "Dick", "Harry")
or
(@Param = "F"
and {your.value} in ["Mary", "Jane", "Sally")
Put this beside the unselected data, where it will say True or False, to check that it works as expected.
Then put the formual field name in record selection, where records will be chosen only if they match.
PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.