How to create a dynamic column name in Cognos?
Answer Posted / pamir
These are the steps -
i. 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).
ii. Highlight the report, and then right-click.
iii. Select Properties, and then click the Headers/Footers
tab.
iv. Clear the Column Title Header check box. This will
remove the headers from your columns.
v. Reinsert the rest of the column headers; insert text
will work.
vi. For the dynamic column, from the Insert menu, click
Data and select the calculated column you created and
insert it into the report.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
explain how to create powerplay reports?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Define datastores in cognos?
What is the function of cognos dispatcher?
What are types of batch available in cognos?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is meant by junk dimension?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
How Metrics Studio is better than Report Studio?
1. Explain your project.
What are the components of the report studio?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What is meant by drill down?