If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Display prompt page filter selection in report.

Started by nimishabrahamc, 07 Aug 2015 08:48:56 AM

Previous topic - Next topic

nimishabrahamc

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

Michael75

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.