Quando omni flunkus, mortati. Die dulci fruere.

| Subscribe via RSS

Monday, January 26, 2009

Freeze rows and columns on Report Studio crosstab


I had a request recently by a business user who wanted to know if Cognos could freeze the header rows and columns of a crosstab (an Excel-like functionality). I found a fairly simple technique on how to accomplish this.


  1. 1. Add two blocks on a blank report page.
  2. 2. Add a table with one cell and one row in the top block (assuming the report contains only one column).
  3. 3. Add a list on the lower block, and a data item from the model (order number).
  4. 4. Select the page, and associate the Query to the page.
  5. 5. Drag a text item in the cell of the table (in the top block).
  6. 6. Select the text item, and in the properties under query items, select order number (see step 3) and content as Label.
  7. 7. Select the second block containing the list.
  8. 8. Under Properties, Positioning, Size and Overflow, set Height = 12 cm and select Use scroll bar when necessary.
  9. 9. Select the Order Number column title in the list. Set its Box Type properties to None.