Skip to Content
0
Former Member
Dec 13, 2007 at 08:24 PM

How do I list choices for parameter values to a stored procedure datasource?

10 Views

Post Author: bkolb

CA Forum: Data Connectivity and SQL

I have created a stored procedure I wish to use as my datasource in Crystal reports. It takes as input a char(16) string which defaults to a value of "Yesterday". The other accepted values are strings like "Today" "Last7Days" "LastFullMonth" , etc. and these are decoded in the SP to actual start and end dates to use in my queries. However, I can't figure out how to list these valid values so users know what's allowed. All I can see is the parameter name (@timeFrame) and a field to type SOMETHING in, along with a check box which is somehow by default checked to mean set the field value to NULL.

Is there any way the various accepted parameter values can be listed?

Is there a way to either defaultedly uncheck the box or completely get rid of it?

Your help is much appreciated.