Getting one Extra row when exporting SSRS report to Excel

Question

I have a simple Reporting Services report, a simple table, created with BIDS 2005, with the report wizard.

I run the report on a RS2008 R2 server as is and it renders perfectly.

When I export to Excel, an extra row is appended just below the table. The row is hidden and has a heigth of 409.5.

Where that row comes from ? How to get rid of it ?

*nb - no extra row if run on a RS2005 server

Answer 1

The only way I found to eliminate the hidden row is change the layout of the report. I increased the height of all rows of from 0,53333cm to 0,538cm. Anything less than 0,538cm doesn’t solve the issue.

According to Microsoft, the goal when exporting to excel is to match the visual appearance of the report as close as possible. The excel output may have unexpected things like extra rows or columns or merged cells as part of the process to match the layout.

Answer 2

Changing the tablix location to 0cm, 0cm , will fix the problem.

Answer 3

I was running into this issue and tried all the posted solutions I could find, but none worked for me. To be more specific, after exporting the SSRS report to excel there was an extra row that contained duplicated data from the first row of the group. This extra row was contained in a group that could be toggled and when that group was collapsed that extra row was still showing instead of nothing.

This was the report layout looked like before I made the change.

What I had to do was add an extra row above and outside the nested grouping by right clicking the group box and selecting "Add row" -> "Outside Group - Above"

Here is the report after.

After adding the rows outside the group there was no duplicated data in an extra row.