General discussion

Locked

Crystal Reports Param Field

By galahad04 ·
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?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Crystal Reports Param Field

by sl-campbell In reply to Crystal Reports Param Fie ...

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)

Collapse -

Crystal Reports Param Field

by galahad04 In reply to Crystal Reports Param Fie ...

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!

Collapse -

Crystal Reports Param Field

by galahad04 In reply to Crystal Reports Param Fie ...

Point value changed by question poster.

Collapse -

Crystal Reports Param Field

by galahad04 In reply to Crystal Reports Param Fie ...

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums