Elegant way to retrieve label of field in a group.

[#1]

I am building charts with dynamic titles.

I have a cyclic group that contains several fields (EX. WORK_USER, WORK_EFFORT, WORK_TEAM, WORK_PROJECT), about 40 fields following a standard naming convention (TABLENAME_FIELDNAME).

Each field has a label that's more descriptive than the name of the field as it's pulled from the database (for example, "User Name" instead of "WORK_USER"

I want to use the label as part of the title of the chart, but haven't figured out an elegant way to do this.

I can use GetCurrentField(groupname) to get the name of the currently selected field in a group, but this gives me the name of the field (WORK_USER) what I actually need to get to is the label of the field "User Name".

Any thoughts?

[#2]

Hi,

Here you are a possible solution.

I hope this helps you.

Best regards.

[#3]

Thanks Miguel, that works perfectly.

I had taken a wrong turn somewhere and was trying to do this with a mapping load

[Marcio_Campestrini]

Thanks Miguel.