Change Parameter info for Stored Procedure

[peterb58]

I am using CRXI connected to Sybase SQL Anywhere.

I am linking to a SP on the DB which has 3 parameters, Start Date, End Data and an Integer.
Crystal has already created these parameters and I can see no way to change the options. I am being forced to use the supplied Calender, but I only want the customer to choose specific months.

Do we have any control over the parameter controls for this.

many thanks

Pete

 

[aks12]

It depends on what you mean by "specific months." One way to do this would be to add those specific months to the parameter's pick list, then set "Allow custom values" to False.

Another way would be to add some customer instruction in your parameter prompting text to choose only certain months. Then put some code in your SP that throws back an error if the user runs the report with any other month.