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