If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Crosstab in Repeater table question

Started by terry_stjean, 17 Nov 2008 09:21:33 AM

Previous topic - Next topic

terry_stjean

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?
...

DanSev

#1
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.