Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Exporting a Cross Tab in Excel

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 Member
replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question