Workbook contains hidden rows and columns when you export reports from SQL Server Reporting Services to Excel

Article translations Article translations
Article ID: 2777223 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When you export a Microsoft SQL Server Reporting Services (SSRS) report to a Microsoft Excel workbook, there are hidden rows or columns in the workbook. The following image is an example of this problem:
Collapse this imageExpand this image
an example of hidden rows

Cause

This problem occurs because row heights or column widths are rounded.

Report Definition Language (RDL) enables you to use several measurement units (for example, inches, pixels, centimeters, and points) to specify position and size values. However, Excel uses only points. Therefore, the SSRS Excel rendering extension converts the height and width of the table, the heights of the rows, and the widths of the columns to points. This process may include rounding some values. In this situation, the table height or width and the sum of the row heights or column widths are different. To compensate for the difference, the SSRS Excel rendering extension inserts a small row or column to the workbook.

Workaround

To work around this issue, specify the measurement unit in points.

Note You can convert other measurement units to points. For example, you can convert inches to points by using a ratio of 1 inch to 72 points.  

More information

For more information about issues that occur when you use the SSRS Excel rendering extension, go to the following MSDN website:

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 2777223 - Last Review: November 19, 2012 - Revision: 6.0
Applies to
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2008 R2 Reporting Services
Keywords: 
kbsurveynew kbtshoot kbexpertiseadvanced KB2777223

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com