layout calculation in column title

[Mita]

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

[dougp]

Excel data or Excel format?

[Mita]

Hi,

It's excel format.



Thanks,
Sasmita

[HalfBloodPrince]

Are you using any style variable to show or hide column ?

[Mita]

yes style variable is used to show and hide the column.

[HalfBloodPrince]

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.

[dougp]

If possible, select the column body or column header and use the ancestor tool to select the column and apply the conditional style there.