Implement condition to parameters and show message to users

[Former Member]

Hi

I have parameters defined :- FromValue and ToValue

How can I implement the condition that ToValue should always be greater than FromValue ?

Also, how can I show message to user for the wrong entry?

Please advise.

Thanks & Regards

Sujata Singh.

[Former Member]

Hello Sujatha,

You can't control the parameter input from the user and also crystal will not display any customized messages.

Thanks,

Sastry

[Former Member]

1. Create a Formula @ReadToValue

If not({?ToValue}<{?FromValue}) then

0

else

2. Create a Formula @ReadFromValue

If not({?ToValue}<{?FromValue}) then

0

else

3. In Record Selection,

XXX in @ReadFromValue to @ReadToValue

4. on Report Header,

You insert a text box with Message "To Value must be bigger than From Value".

right click on this Text box, in the suppress formula, put in

If not({?ToValue}<{?FromValue}) then

True

else

False

Good luck.

p/s: In case anyone is interested, you might think we can achieve the same result in the Record selection by using If statement..... however, you will notice that when condition is used in Record selection, the filtering only happens on the Report level, not at database level, which might affect the speed of the report.

[Former Member]

Many Thanks for showing a way !!!

From Sastry I wunderstand Crystal does not display any customised reporting !!! Thanks Sastry , for also pointing the basics....

[Former Member]

Thanks All !