If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Make filter option for SP query subject

Started by stacybost, 29 Aug 2006 02:34:49 PM

Previous topic - Next topic

stacybost

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

stacybost

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.