Multiple Crosstabs Columns alignment

Multiple Crosstabs Columns alignment

When we have multiple Crosstabs in a single page. If you have very less number of columns in your reports. Most of the time there will not be any issue. But if you any high number of columns then we will get into column alignment issue. Cognos will search all the cells in each column and decide the column width based on its highest cell value length. If you have a two different crosstabs, with first Crosstab having 1M and the second Crosstab with 1K data then you will have the issue. To fix this issue we have different approaches.

Method 1:

Fix all columns with and make the Crosstab Table proper to fixed with. With this option you can improve the performance as well.

1. Select each column and set the width size.
2. Select the each Crosstab and in Table Properties Check fixed size.

Method 2:

1. Unlock the report and Drag blocks into Crosstab nodes and Fact cells.
2. Set the Width size for the blocks.
3. Now drag the cell contents to the blocks.
4. In this approach you will get formatting issue for the cells. As we are moving the cell contents to the blocks. Columns formatting’s will not be applied in the Block. Hence you need to update them manually.

In a very rare cases in both these approaches you will end up with the same issue. The problem for this is may be your column labels length is very high. In these cases you need to split the columns label. Select column label and from the Properties under Font & Text property Change the word break property to break all.