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