Skip to Content
0
Former Member
Jun 26, 2009 at 12:01 PM

Stop Crystal from Prompting for Parameters

22 Views

Hi there,

I am trying to stop Crystal from prompting for a parameter that has the Optional Prompt flag set to True as I want to use the HasNoValue attribute to retrieve all records when there is not a specific value sent to the parameter.

When the parameter is created from a store procedure, I can simply set the value to nothing and handle the resulting NULL in the procedure.

I was expecting that I could do the same for the regular parameters but this returns a "parameter field and parameter field current values are not compatible" error.

I have tried setting the HasCurrentValue to True but this is a read only attribute.

I have also tried setting the Viewer.ReuseParameterValuesOnRefresh to False (and True) but the report still prompts for the parameter.

I have searched the web for the last two days and have had no joy on this so any help or pointers would be appreciated.

Thanking you in advance