Crosstab measures column title will not change?

[jcrouch]

Hi all,

I have a crosstab report that has 3 measures on it. On one of the measures I need to change the column title. I set the Name and Label of the data item to the new title that I want, and in design view that name is shown on the column title (its a 'Crosstab Node Member' object). But when I run the report that column title reverts back to the original field name.

I tried changing the Text Source->Source Type from 'Member Caption' to 'Text' but that caused an error.

Is there a way to do this?

Thanks,

Jeremy

[PRIT AMRIT]

It should work though... Try Unlock the report, then select the Column Tittle (not the column) and then change to Text Source--> 'Text'

Hope should do?

Thanks
Prit

[jcrouch]

Worked! Thanks Prit!

Ive never even looked at that lock button up there, all of my reports have been designed with it being locked the entire time. Ill have to do some research into exactly what that is locking.

[melee]

Worked! Thanks Prit!

Ive never even looked at that lock button up there, all of my reports have been designed with it being locked the entire time. Ill have to do some research into exactly what that is locking.

It should be locked the entire time, unless you're needing to change something like this.. It's very helpful to know though!