Export a report to Excel : Data in a column become several columns

Export a report to Excel : Data in a column become several columns

When i export a report to Excel, the problem is coming, the report data that is in a column become several columns in Excel.

Why the problem happens? How to solve it.

You probably have other items that are either above or below the column that don't align with the column. The excel renderer has to create multiple columns (the report is basically flattened into a table layout) to accomodate all the report items.|||

Oh, Ya! Fang Wang

As you say, it's because my report has a header, so the problem happend!

But the header is required, what can i do?

Thanks!

|||

I have solved this problem!

The solution is simple : i made the header's width equal to the body's width!

[

May i ask some questions about you: Fang Wang is seemed to a Chinese name[王芳or王方]! Are you a Chinese?

]

sql