Exporting a Cross Tab in Excel
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.
Graham Cunningham replied
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.