Software

Ask something
Discussion Locked

Crystal Reports Param Field

0 helpful
4 replies

by galahad04

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a Crystal Reports query that can take parameter values to filter the query based on user input. However, I notice that when I execute the query in the Crystal Reports viewer, I get a dialog prompt titled "Refresh Report Data" that asks me tocheck if I want to "Use current parameter values" or "Prompt for new parameter values."

For this report, the user will always want the second option (to "Prompt for new parameter values"). Therefore, is there a way in Crystal Reports to set thisoption as the default choice -- so that CR will skip the dialog box entirely since this would be the default option?

4 replies

by sl-campbell

It may be better to create a an input box in VB (or a new form) and take the return value of the input box and pass it to CR as a parameter value or, if it is a certain Db field value, pass it as a SelectionFormula.

Parameter values are passed with this syntax:

[form.]Report.ParameterFields(ArrayIndex)[="ParameterName;
NewValue;SetCurrentValue"]

If you set SetCurrentValue to True then the user will not be prompted (only by your input box or form)

by galahad04

Thanks for your suggestion. Unfortunately, using VB is this case is not a viable option since I was supposed to design this project as a web application, not an exe program from VB. Thanks anyway!

This discussion is closed to new replies.