Optional parameters

[JMPS]

Hi

I'm running my report against a stored proc in SQL Server 7, which has one required parameter, and three optional ones, and is being called from VB.

I am only passing the required parameter from the code, and when my report was in Crystal6 it worked fine, but now I've upgraded to Crystal7, an input box appears each time the report is called. I don't want to have to go in and change the code to pass nulls for the three optional parameters, but how can I change the report to not display the input box each time?

Any help would be much appreciated. Jim.

 

[tdz]

set PutEnableParameterPrompting to false and you shouldnt get the prompts anymore. Im not sure if the default "not set" value will be the null that you are looking for, but im betting you can check for that within crystal.

 

[JMPS]

Hi

I can't find this PutEnableParameterPrompting property for the Crystal object - is this just in versions beyond 7?

Also, it would still mean I'd have to alter the code - is there any way of setting this property in the actual report itself?

Cheers, Jim.