COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: nimishabrahamc on 07 Aug 2015 08:48:56 AM

Title: Display prompt page filter selection in report.
Post by: nimishabrahamc on 07 Aug 2015 08:48:56 AM
Hi,

I am new to cognos. I want to display the value selected in the prompt page in the report. For e.g. If I select a particular date in the prompt page, then I need to show that in the heading of the report.

Please suggest me how to do this.

Thanks,
nac
Title: Re: Display prompt page filter selection in report.
Post by: Michael75 on 07 Aug 2015 09:10:32 AM
Hi,

ParamDisplayValue is your friend :)   If you do an Internet search using this keyword, you'll find lots of info on this frequently-raised topic, both on Cognoise and elsewhere.

Generally, you will want to display first a literal (a Text Item), such as 'Requested Date: ', followed by an expression such as
QuoteParamDisplayValue('pReqDate')

Give this a try. You will then probably encounter some formatting issues. It's usually best to put the above values in two columns in a table in the header of your report. Then you can play with left / right justification as well as the formatting of the date component.

Post back if you have further questions.