SQL Server Reporting Services Export to Excel had one blank row got hidden.

Kerry Ou 226 Reputation points
2021-02-23T03:10:14.94+00:00

My RDL report has 3 tables and there is no space among them.

70770-1.jpg

One table for one sheet in excel.

70951-2.jpg

sometimes when exporting to excel, one blank row got hidden at the end of the sheet regardless of how many rows of the export data. (please see the attached pic).

70888-3.jpg

How to solve this problem? Thank you so much.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,852 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 34,581 Reputation points
    2021-02-23T09:11:45.57+00:00

    Hi @Kerry Ou ,

    I did some research online, the issue occurs because row heights or column widths are rounded. The measurement units available in Report Definition Language (RDL) can be inches, pixels, centimeters, and points. However, Excel uses only points. Therefore, the SSRS Excel rendering extension will convert the height and width of the table, the heights of the rows, and the widths of the columns to points when exporting to Excel, which causes the hidden columns and rows.

    To work around this issue, you can specify the measurement unit in points in report definition. For more details, please refer to:

    workbook-hidden-rows-columns

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October


1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2021-02-23T05:52:00.153+00:00

    Hi @Kerry Ou ,

    May I know the version of your SSRS? I tested in my SSRS2017, I didn't reproduce the issue.

    If you are using SSRS 2005, there is a problem when we export the report to excel. After each table or matrix there will be one hidden row even if there is no space between the two in the report layout.

    Even if we give the page break in the next sheet the table or matrix will start from the 2nd row while the 1st row will be hidden.

    This issue has been fixed in SSRS 2008R2 version.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October