I am trying to export report to excel using report manager ,and no gridlines are shown once the report is exported..it should have been basic feature in reporting services .Does any one have a solution to this issue?............ In Crystal Reports you have two options Data Only where you can select different options and just MS EXCEL.....
The Excel that is exported from the Reporting Service will with the gridlines if the textbox with gridlines. In other words, the Excel will be exported without the gridlines if the textbox without gridlines
Hence, if you want to export the report to excel without gridlines, you can use a parameter to set the property “BorderStyle” of the textbox before exporting.
1.Add a parameter in the report, let say WithGridlines.
2.Select all the textboxes.
3.In the Properties panel, set the property “BorderStyle” to be expression as: