A parameter based on the result of another parameter

[AyJayEL]

I want to create a parameter where the users chooses whether a number is less than or equal to 15 or greater than 15. I have created the parameter with => and <. How do I then use that parameter in the next parameter? (Does that make sense?)

I expect this is simple but it's driving me round and round in circles and I should think ultimately round the bend!

Any help appreciated. Learn something new every day *:->*

 

[FoxG]

Hi Andy,

Do you mean you want one parameter that gives one of two results, ie. 15 and under / over 15

You then want the second parameter to have a prompt like
&quot;Enter number&quot; with a drop down based on the value of the first parameter?

It doesn't sound like the sort of thing crystal would do,
as parameter values are saved at report creation time.

I'm sure it would be easily done via a VB front end.

Geoff

 

[AyJayEL]

Actually I think I have done it. Before I left work this evening I had created a parameter where the user chose <= 15 or >15. I then said in the selection

if (paramchooselessorgreaterthan15)= &quot;>15&quot; then DAYS >15 else DAYS<=15. Seems to work! (PS this is not the exact format of the statement as I can't remember it now)

I don't think my initial query was very clear.

Thank you for trying to help. Learn something new every day *:->*