Creating dynamic column heading in UBE

jdeuser2001

Active Member
Hello List Gurus!

I am trying to create a dynamic column heading which would automatically load in the report column heading in a template report "A" and a column overriden report "B"

The column heading should look like this:

January Actuals
---------------
999999.99

Where 'January' is the period name retrieved by using Rolling Column Heading BF and 'Actuals' is a literal constant.

The column heading field name is: RC_Calc

Here is the code I am using:

Rolling Column Headings (loads RC_Calc)
RC_Calc = concat(rtrim(ltrim(RC_Calc),' '),' '),"Actuals")

The result I get from this is:
January
--------------------
9999999.99

The string "Actuals" is missing.

When I revise the code above to use a report variable CLLH1 (column heading 12 chars) the code works in report "A" but not in report "B" even if you create this report variable (CLLH1) in both reports:

i.e.

Rolling Column Headings (loads CLLH1)
RC_Calc = concat(rtrim(ltrim(CLLH1),' '),' '),"Actuals")

Correctly displays

January Actuals
--------------------
9999999.99

in template report "A" but not in column overriden report "B"

Any ideas would be very much appreciated!

Thanks,

Will.
 
Back
Top