COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: adoremars on 30 Sep 2009 08:34:08 AM

Title: Display param value in the output
Post by: adoremars on 30 Sep 2009 08:34:08 AM
Hi All,

I have payment date as a prompt in the prompt page and it has value's like lastweek, MTD, YTD, lastmonth etc. The ouput is a list report where in I need to specify the payment date selected by the user as the header.

eg: Payment date from ------------ to -----------

I guess we need to use param value but not sure how to do that. Any help ??

Thanks..
Title: Re: Display param value in the output
Post by: cschnu on 30 Sep 2009 11:19:45 AM
One way to do it is to set a text item source type to report expression and drag the parameter you want to display into expression box.
Title: Re: Display param value in the output
Post by: rockytopmark on 30 Sep 2009 11:28:04 AM
You will need to used a Layout Calculation (aka: Report Expression).  Code it something like:

'Payment date from ' + paramDisplayValue('pFromDate') + ' to ' + paramDisplayValue('pToDate')