CrossTab column title

[magicksol13]

Hello, does anyone knows how to change the title of a crossTab Column so that it doesn't display the default column name. I tried by unlocking the crossTab Column title zone and inserting a dynamic data item in it and even tried with a singleton I think but can't seem to make it display the crossTab Column title I need.  Thanks!

We are using ReportSutdio 10.2

[Lynn]

Hello, does anyone knows how to change the title of a crossTab Column so that it doesn't display the default column name. I tried by unlocking the crossTab Column title zone and inserting a dynamic data item in it and even tried with a singleton I think but can't seem to make it display the crossTab Column title I need.  Thanks!

We are using ReportSutdio 10.2

Click on a crosstab column (or row) and look for a property called "Source Type". By default this will be set to Member Caption. Click the drop down for this property and you will see the options Text, Data Item Value, Data Item Label, and Report Expression. Perhaps one of these will suit your purpose.

[magicksol13]

Hello Lynn,

Do you mean to click on the CrossTabNodeMember then to change the SOURCE TYPE to Report Expression Under TEXT SOURCE for example ? I'm trying and will let you all know how it goes.

I also already tried to change it to Data Item Value and inserted the Current Year Data Item but no luck.

[Lynn]

Do you mean to click on the CrossTabNodeMember then to change the SOURCE TYPE to Report Expression Under TEXT SOURCE for example ? I'm trying and will let you all know how it goes.

Yes, I am referring to the Crosstab Node Member property for Source Type.

I also already tried to change it to Data Item Value and inserted the Current Year Data Item but no luck.

A little more detail would help.

What type of data source are you using? Relational or Dimensional?

Can you describe what you are putting on the column and what shows by default compared with what you want to show? Why does the current year caption not reflect what you need to see?

What does "no luck" mean? An error? Unexpected result?

Can you mock something up using the Cognos samples to illustrate your dilemma?

[magicksol13]

no worries Lynn as i wqas using 2 DataItems that i created that was name CurrYearSales$ and LastYearSales$ as the columns but i finally used YEAR (i made sure to include CurrentYear and PrevYear in my query filter feeding this crossTab) as my column and simply dragged the original Metric coming directly from the cognos model. Everything is displaying as expected now but thank you for your valuable time and suggestions. This type of cognos forums are really helpful to all of us and the replys we receive are pretty fast. Good day to all.