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

how to display prompt value as a report title

Started by v2k4u, 02 Jul 2013 02:07:54 PM

Previous topic - Next topic

v2k4u

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.

blom0344

ParamDisplayValue(some_parameter) would be the one to use..

v2k4u

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......

adik

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