Report Export to Excel problem in RDLC report

Question

I have added an RDLC report in my .Net application.

Data is generated in reports with the correct design.

But when I tried to export it to Excel, I get several columns merged into several cells ...

How can I prevent columns from merging into cells?

+4

ghanshyam.mirani Oct 05 '12 at 2:04

1 answer

dev_etter · Answer 1 · 2012-10-08T20:05:11+0000

To avoid merging cells in exported SSRS reports, you need to make sure that cell alignment is more convenient for Excel. This can usually be fixed by making sure that the headers and footers match the columns in the details pane . The right side of the header, footer or other object should coincide with the right side of the report columns, as well as for the left.