Exporting a Cross Tab in Excel

[Former Member]

Hi,

I am using a cross tab in the report footer along with the cross tab, i have designed two heading manualy as text objects.

This heading are perfectly aligned at the space which is there at the left corner of cross tab.

But when i am exporting this report file in excel format these heading are not at all alligned with the cross tab.

Please suggest me a way.

Thanks

Deepak

[former_member260594 · Accepted solution]

Deepak,

I am assuming that you are exporting to the Excel Data Only format. This format will always place the crosstab on a new row and this is most likely the cause of the misalignment. I would suggest exporting to the MS Excel 97-2000 (XLS) format as it has more of a WYSIWYG output.