Hi ya'll. I'm trying to change the list header. Instead of showing "PnL Today", I want to change it to
show "PnL 4/1/2009". So I need to concatenate the text PnL and a date variable or data item.
Big thanks.
Hi Endur ,
create the data items as given below....
1) year=extract(year,current_date)
2) month=case extract (MONTH,current_date)
when 1 then 'Jan'
when 2 then 'Feb'
when 3 then 'Mar'
when 4 then 'Apr'
when 5 then 'May'
when 6 then 'Jun'
when 7 then 'Jul'
when 8 then 'Aug'
when 9 then 'Sep'
when 10 then 'Oct'
when 11 then 'Nov'
when 12 then 'Dec'
end
3) day = extract(day,current_date)
4)cast = cast([year],varchar(5))||'-'||cast([month],varchar(3))||'-'||cast([day],varchar(5))||' PnL'
use the last cast data item in your report header .it works.
hope it could help you
vij
:)