Reportviewer - Data merges columns when exported to excel

Question

I am generating a report and exporting to excel, using Reportviewer and Dataset.

Reportviewer consists of a table and two textbox, that refer to the title and company, and an image. After doing some tests it was found that the textbox above the table, one aligned in the left corner and the other in the right, are influencing the merging of the cells, which consequently affect the columns. I would like a help to do that textbox aligned to my right always follow the size of the first column and the left of the last, so that this merge no longer occurs. Can someone help me? I’m using Reportviewer on VS 2008.

Att,

Honan

What should I set up to fix this error?

Answer 1

To avoid merged cells in exported SSRS reports, we have to observe if the cell alignment is equal with Excel.

We can fix by aligning the Report headers and footers with the columns in the detail area.

The right side of a header, footer or other object must be aligned with the right side of the report columns, the same goes for the left.

I hope I help you.