While exporting my ssrs report to excel,i am getti开发者_StackOverflowng 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!!!
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.
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.
精彩评论