COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 04 Nov 2016 05:43:26 AM

Title: How to remove column row from stored produre used in report in report studio
Post by: inu on 04 Nov 2016 05:43:26 AM
Hi Team,

Is it possible to remove the record from the report using stored procedure...
If yes , plz put some light on it for my convenience..
I never used stored procedure.


Regards,
Inam
Title: Re: How to remove column row from stored produre used in report in report studio
Post by: MFGF on 04 Nov 2016 09:14:42 AM
Quote from: inu on 04 Nov 2016 05:43:26 AM
Hi Team,

Is it possible to remove the record from the report using stored procedure...
If yes , plz put some light on it for my convenience..
I never used stored procedure.


Regards,
Inam

What do you mean by "remove the record"? Are you talking about filtering rows? Is this a report based on the results of a stored procedure, or do you want to create a stored procedure to do something? Can you explain?

MF.
Title: Re: How to remove column row from stored produre used in report in report studio
Post by: inu on 04 Nov 2016 09:36:31 AM
Quote from: MFGF on 04 Nov 2016 09:14:42 AM
What do you mean by "remove the record"? Are you talking about filtering rows? Is this a report based on the results of a stored procedure, or do you want to create a stored procedure to do something? Can you explain?

MF.

yes correct MF.
we would need to remove KPI rows depending on the result.
So what logic should we apply here.
Thanks for understanding the problem.

Regards,
Inam
Title: Re: How to remove column row from stored produre used in report in report studio
Post by: MFGF on 04 Nov 2016 09:53:53 AM
Quote from: inu on 04 Nov 2016 09:36:31 AM
yes correct MF.

Which part is correct? That you're talking about filtering? That you have a report that is currently based on the results of a stored procedure? That you want to create a stored procedure to do something?

Quote from: inu on 04 Nov 2016 09:36:31 AM
we would need to remove KPI rows depending on the result.
So what logic should we apply here.
Thanks for understanding the problem.

Depending on what result? Can you explain your requirement?

MF.