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.
1. add a data item to the query(the query on which the report is based) 2. define an expression which u want to use for the dynamic column label 3. from the report page click on the column label 4. from properties pane look for "column label" the default would be "data item label/name" change that to "data item value" 5. in the same pane change the "data item" property to have the data item that u created for the column label.
RE: How can I create a dynamic column name in Cognos
For making a column dynamic you have to insert layout calculations from the objects pane in COGNOS 8 report studio. I was a bit confused with the previous answers from different ppl.
RE: How can I create a dynamic column name in Cognos
1. add a data item to the query(the query on which the report is based) 2. define an expression which u want to use for the dynamic column label 3. from the report page click on the column label 4. from properties pane look for "column label" the default would be "data item label/name" change that to "data item value" 5. in the same pane change the "data item" property to have the data item that u created for the column label.
RE: How can I create a dynamic column name in Cognos
Create dataitem by using cast function and use that data item value for the dynamic column name by changing the source value (name under properties) for the column you need.
RE: How can I create a dynamic column name in Cognos
The requirement was some thing like the heading's of a list report is supposed to be dynamic. Column Name should be in the format as shown: Total Budget XXXX where XXXX represents year like next year or previous year etc. (ie. XXXX can be 2009 2008..)
1. Add a data item to the query (the query on which the report is based)
2. Define an expression which u want to use for the dynamic column name
3. Go to the report page and then unlock the lock at the top menu.
3. On report page click on the Source Type and change that to the data item value
5. In the same pane change the Data Item Label property to have the data item that was created for the column label.
3 
0