Author Topic: How to create one shared column title for two list columns in report header in c  (Read 64 times)

0 Members and 1 Guest are viewing this topic.

Offline MrSpecialist

  • Sr. Member
  • *
  • Posts: 342
  • Karma: +1/-0
  • I'm an expert!
    • View Profile
How to create one shared column title for two list columns in report header in cognos 8.4

A list report with multiple columns. How to create a column title put it on top of two column titles and make it look like in Excel spread sheet format? For example, Product as a column title, another two columns sub titles as Product Line and Product Type.


Resolving the problem

Use Create Header toolbar button to add a list or page header row. By default, all headers are displayed below the Column Titles; this can be changed by setting the "Column Title" property of the list ojbect to "At start of details". Now we can split the summary header then merge the columns header as we wish.


Steps:
1.Create the list report with the fields required.

2.Click any cell in the list.

3.On the toolbar, click Create Header.

4.Use the Ancestor control to select the list object.

5.In the Properties pane, under General, locate the Column Titles property and set it to At start of details.

6.To have the heading to appear on all pages, select the new summary row, click the Ancestor control, and select List Header. In the properties, select Pagination, in the resulting dialog, click Repeat every Page.

7.Select the summary row in the report, and on the toolbar, click the Split Cell button. This will split the header row into its individual cells.

8.To have more then one row, click Structure, and Insert List Row Cells Above or Below.

9.Now, select any number of adjacent cells, and click Merge Cells to merge them.

10.Add the desired text to the cell.

Techronnati | where technology never sleeps


Mountain View

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
136 Views
Last post August 15, 2008, 07:24:57 AM
by CyborgRepublic
1 Replies
107 Views
Last post October 29, 2008, 08:20:15 PM
by rpmolecule
0 Replies
56 Views
Last post April 02, 2009, 05:40:02 AM
by MrSpecialist
0 Replies
55 Views
Last post December 14, 2016, 10:15:08 AM
by MrSpecialist
0 Replies
59 Views
Last post December 14, 2016, 10:37:44 AM
by MrSpecialist

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.