Prompt values in Report Header

[nfldbunker]

hi I have a basic report that has a value prompt for a date range (from and to) which i want to display in the report header. If i select April 1 - June 31, i want my report title to reflect Report titile fopr the period from April 1 - June 31

Any suggestions would be greatly appreciated.
:)
 

[billylodz]

ParamDisplayValue()

[Gopinath]

Hi billy,

ParamDisplayValue() for a date range prompt will return value something like

'Between from_date and to_date'

Bunker,

Try to extract the from date and todate value from the prompt parameter using

substring() and position() functions

[nfldbunker]

hi, i am faily new to cognos. how would i achieve this? You select a a from date and to date and and select a range of codes.I want the dates selected  on the report title

Ie:

Report Title
for the periods 04/01/08 to 07/31/08

where would i create this in the prompt page or report layout page

thanks'

[ajaju]

Hi,
To get the date on the report header follow below steps:

1)Go to the report page.
2)Take a Text Item in the Header
3)Select the Text Item.In the properties window under source type select Report Expression.
4)Below source type you have one more property as Report Expression.Click on the browse field.
5)After this a new window will open.Below available components you will have three tabs.Click on last tab i.e     Parameters
6)You will get youR date field.Drag that date field in th expression details space and click ok.
7)Go to your report page and run the report

HTH!
Cheers!

[nfldbunker]

hi

thanks for the info. I will test and report back. I think this will work.

thanks again

bunker

[nfldbunker]

works perfectly

bunker thanks for the tips