Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: v2k4u on 02 Jul 2013 02:07:54 PM

Title: how to display prompt value as a report title
Post by: v2k4u on 02 Jul 2013 02:07:54 PM
Hi All,
I would like to show Prompts values in Report Title. But Could not find out how to do. Could you please help me on this? I had defined below prompt on one of the report:
Select Date Prompt
Just say if user select 2011 and JUNE 1 from Date Prompt , then I want to display these values on Report Title.
Title: Re: how to display prompt value as a report title
Post by: blom0344 on 02 Jul 2013 02:22:21 PM
ParamDisplayValue(some_parameter) would be the one to use..
Title: Re: how to display prompt value as a report title
Post by: v2k4u on 02 Jul 2013 03:07:53 PM
i want it in 2011Q2 format. to_char(_add_months(?Parameter1?,0),'YYYY')+'Q'+to_char(_add_months(?Parameter1?,0),'Q') is the one which i was using in the data item, but want to know how we show it as 2011Q2 on the header of the report......
Title: Re: how to display prompt value as a report title
Post by: adik on 03 Jul 2013 01:58:10 AM
why are you doing this: _add_months(?Parameter1?,0)
what is the point of adding 0 months?
as for displaying this data item use a Singelton (you will find it in the Toolbox) and place the data item in the Singleton
Text only | Text with Images