Column Header

rbrooks

Is there anyway to get a column header other than one you enter? I would like the column header to update based on the date filter. I use a rolling 12 month comparison report of the previous 12 months of various GL accounts and my column headers are each of the previous 12 months. When I run the report of a new period I would like to see the column header change automatically to the appropiate month.

Thanks,
Rbrooks

kapamarou

Use a textBox with textConstants instead of a label...

rbrooks

Thanks for the reply, but could you be a little more specific. When I run 'help' on textBox or textConstants I get nothing.

Thanks,

Rbrooks

kapamarou

I suppose you are talking about a report.

So from the toolbox, add a new textbox.

Create a Text Constant in the Global Variables like this:

Name: Text0001 Value: This is a label for period: %1

Add a global text variable and set it as the source of your textbox.

Then do: globalTextVariable := STRSUBSTNO(Text0001,FORMAT(DatePeriod));

Something like that...