COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: FirstStruck on 16 Apr 2013 09:50:05 AM

Title: SOLVED: Display Parameter in Report
Post by: FirstStruck on 16 Apr 2013 09:50:05 AM
Hi everyone!

I want to display the paramater I selected from the prompt page in the report output.

The parameter is a date range. (In_range)

On the report, I added a singleton and put a query calculation inside.

For the query calculation I put ?Parameter2?.

The output is only giving me the first half of the date range. For example, when I select 2.1.13 to 2.28.13 it displays:
2013-02-01T00:00:00.000

Any advice on how I can get it to display both the first date selected and the last date?

Thanks for your help and time!  ;D
Title: Re: Display Parameter in Report
Post by: FirstStruck on 16 Apr 2013 10:00:24 AM
I always find solutions here using the search function AFTER I post  :o

Solution:
-Add a text
-source type: report expression
-report expression: ParamDisplayValue('Parameter')

Output couldn't be more perfect:

Between Feb 1, 2013 and Feb 28, 2013

LOVE THIS WEBSITE!