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

Title: Pass Null values to Sql Server Stored Procedure from Cognos Framework manager
Post by: santosh.yelugoi on 05 Oct 2016 05:14:39 AM

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.

Title: Re: Pass Null values to Sql Server Stored Procedure from Cognos Framework manager
Post by: Mita on 28 Nov 2016 04:36:18 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: santosh.yelugoi on 05 Oct 2016 05:14:39 AM