COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: vsudaya on 15 Dec 2005 02:54:08 AM

Title: Dynamically generating list column titles
Post by: vsudaya on 15 Dec 2005 02:54:08 AM
Hi all,

Has anybody got idea about how to generate list column title from a table, i have created list with 100 column, i want the list column titles to be generated from a table instead of manually changing the list column text every time.

Thanks in advance.
vsud
Title: Re: Dynamically generating list column titles
Post by: BIsrik on 15 Dec 2005 06:17:17 AM
the best way would be rename all ur column in the table to the respective column headings in the FM model. Then just pull the columns.

Thats it...

Srik
Title: Re: Dynamically generating list column titles
Post by: bdybldr on 15 Dec 2005 07:40:40 AM
Vsud, Can you explain in more detail what you're trying to do?  I'm not understanding the requirements.  Did Srik's solution solve the problem?  Thanks.
Title: Re: Dynamically generating list column titles
Post by: vsudaya on 19 Dec 2005 03:07:43 AM
Hi Srik/all

Without renaming column in FM model, can i do it in report studio by changing data item name in list colum properties. Even if it looks like changed in report studio, when i run report , output it showing old meta data name only( for eg: for "emp_id" i am giving "emploee id", but it reflecting the same emp_id in output)

any solutions?

thanks in advance
vsud
Title: Re: Dynamically generating list column titles
Post by: MFGF on 20 Dec 2005 06:58:01 AM
Unlock the structure of the report (press the padlock button), then select the text item in each column heading and change the text.  This should work.

Best regards,

MF.
Title: Re: Dynamically generating list column titles
Post by: tsrikanth on 20 Dec 2005 10:08:28 AM
Quote from: vsud on 15 Dec 2005 02:54:08 AM
Hi all,

Has anybody got idea about how to generate list column title from a table, i have created list with 100 column, i want the list column titles to be generated from a table instead of manually changing the list column text every time.

Thanks in advance.
vsud