COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: morphy on 13 Dec 2009 12:26:22 AM

Title: Cross-Tab problem
Post by: morphy on 13 Dec 2009 12:26:22 AM
Hi all,

I created a cross-tab like this one below:



                | 1/3/2009 | 2/3/2009 | 3/3/2009 | .......
--------------
1 |  engin  |      1          1          1
2 |   pump |
3 |  wires   |


It works perfectly but now i would like to insert a row above the data of the y-axis in which to write the labels(ID, DESCRIPTION...).

I would like to obtain a cross-tab like this one below:


                 | 1/3/2009 | 2/3/2009 | 3/3/2009 | .......
ID|   DESCR
----------------
1 |    engine  |      1          1          1
2 |    pump   |
3 |    wires    |


How can I do that?

Thank u all in advanced.

Best Regards.

Matty
Title: Re: Cross-Tab problem
Post by: CognosPaul on 13 Dec 2009 04:05:02 AM
Drag a crosstab space directly to the left of the date node. Unlock, add a text item with to the header. Click on the fact cells of the crosstab space and set box type to none. Click on the crosstab corner and set box type to none.

Repeat for each nested node in rows.