COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kris123 on 11 Sep 2012 11:25:00 AM

Title: where is ParamValue?
Post by: kris123 on 11 Sep 2012 11:25:00 AM
Just wondering where the function Paramvalue is ?

please can you point me in the right direction to find it.

I always want to choose operation rather than typing...is this the way one should create expressions?
Title: Re: where is ParamValue?
Post by: tjohnson3050 on 11 Sep 2012 12:24:42 PM
If you are using a layout calculation, in the report functions you have ParamValue as a choice.

If you are in a data item calculation, the parameter values are listed by name on the last (5th) tab on the available components screen.
Title: Re: where is ParamValue?
Post by: HalfBloodPrince on 12 Sep 2012 12:50:06 AM
ParamValue ('parameterName')
Returns the parameter value of "parameterName".
ParamDisplayValue ('parameterName')
Returns a string that is the parameter display value of "parameterName".
Title: Re: where is ParamValue?
Post by: sony on 12 Sep 2012 09:34:19 PM
Hi,

If you are looking for Param meter value in the query then you can drag from the last tab in the dataitem when you drag it to the dataitem window it looks like ex: ?ParameterName?. :) :)
Title: Re: where is ParamValue?
Post by: kris123 on 13 Sep 2012 08:18:21 AM
I dont think it is a layout calculation.
please see steps in the attached.

I had to type paramvalue manually
Title: Re: where is ParamValue?
Post by: tjohnson3050 on 13 Sep 2012 10:19:41 AM
In this case, you type it in, not select it from a list.