reportinggroupingcognos

How do I keep Cognos from splitting my subgroups across pages?


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.


Solution

  • well, a litle bit out-dated, but nevertheless here is what worked for me:

    1. unlock
    2. place a 1x1 table object inside the Regions cell
    3. place the regions name inside the table object (just drag it inside the table)
    4. in the table's paginations properties deselect the option Allow row contents to break across pages

    you might also need to specify the height of the table object.