COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: richiearora on 10 Mar 2011 11:23:31 PM

Title: How to Display Prompt value in Parameter Table of report Output Conditionally
Post by: richiearora on 10 Mar 2011 11:23:31 PM
Hi All,

I have a Optional Prompt,

Now my requirement is if user choose any value in that then only that should be displayed in my Report Output Parameter table.

Please help very urgent..
Title: Re: How to Display Prompt value in Parameter Table of report Output Conditionally
Post by: PRIT AMRIT on 10 Mar 2011 11:38:20 PM
Do you mean, if the optional prompt is selected, then your report output parameter table should only show that value and other parameter values would be hidden?
Title: Re: How to Display Prompt value in Parameter Table of report Output Conditionally
Post by: richiearora on 11 Mar 2011 12:25:51 AM
Yes Prit, I mean the Same.

Title: Re: How to Display Prompt value in Parameter Table of report Output Conditionally
Post by: PRIT AMRIT on 11 Mar 2011 01:21:51 AM
Create a boolean variable: E.g

if ParamDisplayValue('Parameter1') is missing

Just show/hide the parameter table in your report based on the boolean variable.

It should do.

Thanks
Prit
Title: Re: How to Display Prompt value in Parameter Table of report Output Conditionally
Post by: richiearora on 11 Mar 2011 03:59:57 AM
Thanks fr the Suggestion prit..

I am Just wondering how do i write expression for Conditional Variable

My Value Promopt is List Box which have 12 values.

ParamDisplayValue('List Prompt')

How do i use thit i am not sure any suggestions is welcome