Multiple Parameters

[ForMe2]

How do I add multiple parameters for different fields so the user may choose just one criteria for one field? (So, they wouldn't have to choose 3 criterias) For example, they would want to filter the report {field.color}= red & sometimes they would want to filter it {field.date}> 1/28/07.

 

[Madawc]

You could enter a parameter code and select using that. Make a boolian with a name like @MultiChoose,

(?CHOICE = "R" and {field.color} = "red")
OR
(?CHOICE = "D" and {field.date} > Date(2007, 01, 28)

Then say If @MultiChoose in the record selection and it should be OK.

For dates you'd probably want a moving date based on the current date, you get this with CurrentDate and DateAdd (which can subtract).

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods change between versions, and higher versions have extra options.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10