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