If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos 8 Report Studio report with static column headers

Started by shantar28, 28 Jul 2006 11:48:28 AM

Previous topic - Next topic

shantar28

I'm trying to create a simple list report with static column headers, but am unable to get the page break step just right to allow for the column titles to remain fixed. The effect is the same as a freeze panes in Excel.

I want the column headings to be frozen and to be able to scroll down to all of the data without the column headings moving.


Thanks,
Shawn

bonniehsueh

I would try this, sounds similar to what you are looking for.
Author: Dariusz Danielewski 
Subject: Freeze Column Headers in a Report


Description:

How do you freeze column headers in a report when you scroll down the page?

Solution:

Use the following steps and the attached report specs.

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 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, Height = 12 cm and select Use scroll bar when necessary.

9. Select Order Number column title in the list. Set the Box Type properties to None.





Additional Information



In order to have the columns and headers align properly you will need to set both the list properties and table properties to fixed and then set the size and overflow for each column and it’s corresponding header.  They will no longer dynamically change in size when the web browser window is resized or the content size changes.  The text will wrap in the cell if it is too large.