I have a report which uses a Crosstab in a Repeater table.
I used the Repeater table so I could repeat the crosstabs horizontally in the report.
In the repeater table, I have the level Product Type, a cross tab with months as rows and a couple of measures as columns and a couple of lists.
For the crosstab, the rows are always going to be the same for each crosstab, is there a way to suppress the row names after the first crosstab.
I current get this.
Prod Type 1 Prod Type 2
Sales Quantity Sales Quantity
Jan $xxx xxx Jan $xxx xxx
Feb $xxx xxx Feb $xxx xxx
Mar $xxx xxx Mar $xxx xxx
...
Is there a way I can change it to this.
Prod Type 1 Prod Type 2
Sales Quantity Sales Quantity
Jan $xxx xxx $xxx xxx
Feb $xxx xxx $xxx xxx
Mar $xxx xxx $xxx xxx
...
I want to stop repeating the row names in each crosstab after the first one.
Any ideas?
...
This is dependant on what version of Cognos you are using.
Try this -- put Prod Type 1 and Prod Type 2 in the same query, then add a crosstab space to the right of Prod Type 1 and another under it. Then you can add Prod Type 2 to the right of that. See the sample report.
Additionally you can set the box type of the month nodes to none, which would also cause them not to be displayed.