Hi, I am getting extra column while exporting SSRS report into excel but those columns not in my report.how to avoid these columns please find the attached screen shot whith red circle.

When the reports get exported to Excel, extra columns get created. The cause of this 'behaviour' is the alignment of the objects on the report. Every textbox, tabel, graph and so on needs to be exactly aligned to one another. And make sure that textboxes and other objects align with columns in tables. If a textbox starts at the same x-position as your table, but if it ends in the middle of a table column, you will get extra and merged columns in Excel. If the right side of the textbox ends at the same position as one of the table columns, the export to Excel will show no extra columns.

Hello, When we export a SSRS 2008 R2 report that uses the visibility toggle feature to an Excel workbook, the Excel worksheet has unexpected automatic subtotals. This issue occurs because of an error in the Excel renderer in SQL Server 2008 R2 Reporting Services. For more information, please refer to the following KB article, and install the Cumulative Update 5 or the most recent fix release for this issue. http://support.microsoft.com/kb/2462084 Regards, Fanny LiuFanny Liu TechNet Community Support