COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Mita on 13 Jun 2016 06:19:17 AM

Title: layout calculation in column title
Post by: Mita on 13 Jun 2016 06:19:17 AM
Hi All,

I am facing a problem like below,

I have a layout calculation in the column title ,the column is a dynamic column.

while extracting the report to excel ,the layout calculation is appearing as a new column with some other columns data.

Can any body tell me where am i going wrong?


Regards,
Sasmita
Title: Re: layout calculation in column title
Post by: dougp on 13 Jun 2016 06:32:24 PM
Excel data or Excel format?
Title: Re: layout calculation in column title
Post by: Mita on 14 Jun 2016 01:17:03 AM
Hi,

It's excel format.



Thanks,
Sasmita
Title: Re: layout calculation in column title
Post by: HalfBloodPrince on 14 Jun 2016 01:37:38 AM
Are you using any style variable to show or hide column ?
Title: Re: layout calculation in column title
Post by: Mita on 14 Jun 2016 02:17:28 AM
yes style variable is used to show and hide the column.
Title: Re: layout calculation in column title
Post by: HalfBloodPrince on 14 Jun 2016 02:49:50 AM
Issue seems to be  style variable is applied only to column title so its getting hidden and title of column next to it getting appended to it. Better apply the style variable same way to column body style as well for those have dynamic column names.

Title: Re: layout calculation in column title
Post by: dougp on 14 Jun 2016 10:17:21 AM
If possible, select the column body or column header and use the ancestor tool to select the column and apply the conditional style there.