hi guys,
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!!!
A:
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.
Mark Bannister
2010-07-07 10:00:12
Yeah..After setting borders to the cells of a table in ssrs report,i can view the borders only for that particular table while exporting that report to excel.The rest of the cells in the Excel sheet remains with white background only.I just want to display the entire excel sheet with gridlines.Is there any provision to do this?
Meera
2010-07-08 05:51:03
I don't know of any within SSRS, although it's easy enough in Excel - just click the top left hand corner of the sheet to select all cells, then select the All Borders option from the Borders menu.
Mark Bannister
2010-07-08 10:24:47
thanks..........
Meera
2010-07-09 10:48:23