Pass Null values to Sql Server Stored Procedure from Cognos Framework manager

[santosh.yelugoi]

Hi All,

Here I have an requirement.
When we pass a null value to one of the parameter of a the SQL Server Stored Procedure it will return all the values without any filter criteria.

So how to pass NULL to SP from Cognos Framework Manager.

I am using Cognos 10.1.1 version.

Thanks in advance for your reply.

[Mita]

Simply you can declare NULL in the parameters defined in procedure which you will be using as prompts in report.
and make it as optional .when you will not select any thing it will automatically filter all the valuees