CODEWITHSUNDEEP
reporting-servicesreportbuilder
taty
taty

Reputation: 23

Hidden extra field in Excel after export from ssrs

I get hidden extra fields in my report in Excel after export from SSRS.

There is only 1 table in report. All columns have same size.

SQL Server 2014, Report Builder 3.0

Please any help.

Kindly Taty

enter image description here

enter image description here

Upvotes: 1

Views: 727

Answers (2)

Regret
Regret

Reputation: 51

It could be that your report contains hidden columns. Hidden Columns in your report are not removed, only hidden. so they get copied when you export to Excel.

Open the report in report builder and check if there are columns there that are not shown in the report.

Upvotes: 0

SMM
SMM

Reputation: 2235

When we see extra fields in the Excel export it is usually because a text box not in the main tablix has an edge that does not align with the fields in the tablix. Make sure that all fields not in the tablix (including header and footer fields) have their edges aligned with a tablix field edge.

Upvotes: 1

Related Questions