Author Topic: How can I create a dynamic column name in Cognos?  (Read 107 times)

0 Members and 1 Guest are viewing this topic.

Offline h2obubbler

  • Full Member
  • *
  • Posts: 226
  • Karma: +0/-0
  • Life is like a box of chocolate.
    • View Profile
How can I create a dynamic column name in Cognos?
« on: October 29, 2008, 08:18:35 PM »
Was wondering if anyone here in the forum know how to do it. I was creating a report which i want one column to display column name dynamically. How do i achieve this? Any idea?

Techronnati | where technology never sleeps

How can I create a dynamic column name in Cognos?
« on: October 29, 2008, 08:18:35 PM »

Mountain View

Offline rpmolecule

  • Full Member
  • *
  • Posts: 224
  • Karma: +1/-0
  • Seize the Day!
    • View Profile
Re: How can I create a dynamic column name in Cognos?
« Reply #1 on: October 29, 2008, 08:20:15 PM »
Hi,

You may want to try this one.

1.Create a calculated column which contains the information that the header is to contain, such as "Report for year 1999" (concatenated text and date to string sub string extraction).
2.Highlight the report, and then right-click.
3.Select Properties, and then click the Headers/Footers tab.
4.Clear the Column Title Header check box. This will remove the headers from your columns.
5.Reinsert the rest of the column headers; insert text will work. For the dynamic column, from the Insert menu, click Data and select the calculated column you created and insert it into the report.

Thanks.

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
136 Views
Last post August 15, 2008, 07:24:57 AM
by CyborgRepublic
0 Replies
55 Views
Last post April 02, 2009, 05:40:02 AM
by MrSpecialist
0 Replies
62 Views
Last post April 02, 2009, 05:54:22 AM
by Transformer10
0 Replies
60 Views
Last post August 17, 2016, 10:08:01 AM
by h2obubbler
0 Replies
63 Views
Last post December 14, 2016, 10:13:40 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.