CODEWITHSUNDEEP
c#asp.netreporting-services
M3ra
M3ra

Reputation: 229

Problem on Exporting SSRS reports to Excel

While exporting my ssrs report to excel,i am getting that report with white background in excel sheet instead of displaying those data within the gridlines.How can i do this?

Please help me to get a solution for this!!!

Upvotes: 1

Views: 3715

Answers (2)

BrettFromLA
BrettFromLA

Reputation: 916

I wanted to add another solution in case anyone else has a mostly-white Excel worksheet (with no visible gridlines). What I mean is that cell IV65536 had no visible border. The solution is really simple:

1) go to the View ribbon
2) find the Show group
3) put a check in the box for "Gridlines"

For some reason, the SSRS default is to uncheck the "Gridlines" box.

Upvotes: 1

user359040
user359040

Reputation:

By setting the Border options in the properties dialog for your report objects. Don't forget to set the Border Colour, Border Style and Border Width properties - if you have the Colour set to black and the Width set to 1pt, but the Style set to none, you won't see any borders around your cells.

Upvotes: 0

Related Questions