Making parameter entry required

[Meredith]

Does anyone know how to force a user to enter a parameter (specifically a date parameter)? I don't/can't have a default value and I'm not sure how to force a user to enter a date.

Thanks,
Meredith

 

[synapsevampire]

If the user doesn't want to enter a parameter, Crystal won't force them to. You could however create a Report Header Section which is conditionally suppressed unless the date changes from a set default value, or currentdate or whatever, which would pop up some gentle reminder like "C'mon ya lazy sod, enter a proper date parameter!", and you could even limit the data based on what's entered to not return any rows.

You can use parameters(Insert->Field Object->Right click parameters and select New, and default values will allow you to prefill them), and you can add them to the record selection formula to filter data (Report->Edit Selection Formula->Record and use something like:

{mytable.myfield} = {?ParmName}

And you can display/print out the parameters chosen by the user by using:

join({?ParmName},", &quot

-k-

 

[Ngolem]

hmmmm...if there is no value set as the default...doesn't crystal always prompt for one??? Think so...especially if it were part of a record selection formula

Just make sure you don't have the convert nulls to default vales set.....if that affects parameter input that would be another reason for NOT ever setting it.

Jim Broadbent