Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Parameter info for Stored Procedure

Status
Not open for further replies.

peterb58

IS-IT--Management
Mar 20, 2005
110
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top