Hi I'm on CR2008/ BO Universe 12.03/ Ora 11. I have a cross tab in RF which is based on the following:
Rows - Project Reference & @Res_Task_Concat ({dhResourceHoursUni_query.Prname} +" - "+ "("+{dhResourceHoursUni_query.Full Name}+")")
Column - @PrStart_Conv (totext({@PRstartdate},"MM/yyyy"))
Summary - Running Total on hours worked by day rate (with floating currency set for all elements
Suppress Column Grand Totals only
The weird thing is on page one of the rpt only the row totals show with a £, the month calculations don't. On page two all elements have £ showing. There are no formulas set in section expert either at GH or GF level. Never seen this happen before! There are no currency formulas/ calculations being applied at the BO 'derived table' level - all just regular data. Anyone ever see something like this? Thanks if you provide any input.
B
Rows - Project Reference & @Res_Task_Concat ({dhResourceHoursUni_query.Prname} +" - "+ "("+{dhResourceHoursUni_query.Full Name}+")")
Column - @PrStart_Conv (totext({@PRstartdate},"MM/yyyy"))
Summary - Running Total on hours worked by day rate (with floating currency set for all elements
Suppress Column Grand Totals only
The weird thing is on page one of the rpt only the row totals show with a £, the month calculations don't. On page two all elements have £ showing. There are no formulas set in section expert either at GH or GF level. Never seen this happen before! There are no currency formulas/ calculations being applied at the BO 'derived table' level - all just regular data. Anyone ever see something like this? Thanks if you provide any input.
B