I am reporting off of a cube into a crosstab with the results being summarized. For example:
| Val 1 | Val 2
----------------------------------------------------
Division 1 | Region 1 | Location 1 | 5.00 | 3.00
| |-----------------------------
| | Location 2 | 2.00 | 6.00
| |-----------------------------
| | Reg Sum | 7.00 | 9.00
|----------------------------------------
| Region 2 | Location 1 | 4.00 | 3.00
| |-----------------------------
| | Location 2 | 12.80 | 7.40
| |-----------------------------
| | Location 3 | 5.00 | 11.00
| |-----------------------------
| | Reg Sum | 21.80 | 21.40
|----------------------------------------
| Div Sum | 28.80 | 30.40
----------------------------------------------------
Division 2 | Region 1 | Location 1 | 3.00 | 12.85
etc...
Currently, Cognos is breaking the page in the middle of the Division 1/Region 2 subgroup. If the whole region subgroup (including summary) doesn't fit on the remainder of the page, I want it to go to the next page.
I've tried pagination at the region and location level. That has not given me the results I want. Any ideas as to how I can achieve this?
EDIT: Forgot to mention that this is Cognos 8.4.
well, a litle bit out-dated, but nevertheless here is what worked for me:
you might also need to specify the height of the table object.