Is there a way to make parameters passed to a stored procedure optional?
I have a sp query subject. Inputs to the SP are period_id and week_id. If a user selects a period but no week, the SP returns data for the period.
If I have two prompt in CRN, one for period and one for week (not required), how can I make the SP Query Subject not require week_id?
Hope that questions makes sense...
Thanks,
Stacy
FYI...
I've discovered that the answer is NO, filters passed to stored procedures are not optional.
An enhancement has been requested for this feature.