Manoj Nayak
Manoj Nayak

Reputation: 2509

SSRS 2008 Excel Export Issue

I am using ssrs 2008. The report exports as expected in dev server and local machine. Whereas in Prod server the report is fine when exported to PDF but when exported to excel i am unable to view any borders.

UAT result is below enter image description here

Upvotes: 2

Views: 155

Answers (1)

I_Al-thamary
I_Al-thamary

Reputation: 3993

I found this answer: Set the BorderStyle to be like this

BorderStyle = Dotted; ; ; ; Solid

source:https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e11a0cf3-3494-437e-95e8-71a583c1c8eb/cell-border-formatting-gets-lost-when-using-excelexport?forum=sqlreportingservices

As well as, there is a different suggestion, you can find it below:

Exporting Conditional Borders to Excel in SSRS

Upvotes: 1

Related Questions