Organization Hierarchy: using the value of one field as the heading for another.

Martin Lowe

If the content of the field "Organization Hierarchy"."Level 01 Organization Classification" is "Division",

how can I use this content to be the column heading for "Organization Hierarchy"."Level 01 Organization Name"?

gclampitt

You can't have a dynamic column name based upon data

Rich Merkel

Not sure exactly as the design goes…

but could you just create two columns

 "Organization Hierarchy"."Level 01 Organization Classification" is "Division"

"Organization Hierarchy"."Level 01 Organization Name"

each has the column name you want to display.

Used advanced suppression, if

 "Organization Hierarchy"."Level 01 Organization Classification" is "Division"

suppress the column

same on other column, just opposite way so it suppresses

 "Organization Hierarchy"."Level 01 Organization Name"

if

 "Organization Hierarchy"."Level 01 Organization Classification" is NOT "Division"

So in summary, create the two columns with two different headings, use avandced suppression on each column to determine which column you show in what scenario.

Maybe that can work.