SQL Server 2012 SSRS Export to Excel repeats border when no border is specified by Josh George

Active

Type:	Bug
ID:	778470
Opened:	2/4/2013 8:19:40 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

When you have a financial report format in an SSRS table in SQL Sever 2012 (any version), and you try to export only to Excel (all others look fine) you get extra borders outlined where there is not supposed to be any. For example, if you only want to set the bottom border to solid for row 2 of a table and you have a total of 10 rows, rows 2-10 will have a bottom border when exported to Excel.

Details (expand)

English

SQL Server 2012 SP1

Reporting Services

Windows Server 2012 (all editions)

US English

1) Create a new report with the following query attached to AdventureWorks: SELECT ProductID, Name, ProductNumber
FROM Production.Product

2) Place a table in the report with the 3 columns pointed to the results set from above

3) Select all of the cells in the table and set the default BorderStyle to be "None".

4) Select the Details group cells (data cells) and set the Bottom BorderStyle to be: =iif(RowNumber(Nothing)= 2, "Solid", "None")

5) Preview report (you can also deploy to SharePoint or ReportManager to display, they have to be using SQL 2012 bits).

6) Export to Excel

For testing purposes use this formula for step 4 and then repeat steps 5 and 6:
4) Select the Details group cells (data cells) and set the Bottom BorderStyle to be: =iif(Fields!ProductID.Value = 2, "Solid", "None")

I can also provide a sample report if needed.

If you perform these same steps in 2008 R2 you do not get the extraneous lines.

ONLY in SQL 2012 will get a result that will have row numbers 2 - XX have the bottom border be set to Solid. SQL 2008 R2 does not have this issue.

Expecting to have ONLY row number 2 to have a bottom border as seen in the report display and any other export.

X64

0 attachments

Microsoft