We have a number of SSRS reports and want to show the report in Excel format to the users. SSRS has provided an option to save the report in Excel format (
.xls), however when the report is saved as Excel, all the cell borders are gone and the spread sheet background color is white. For example:
Is there any way to prevent it from happening? So the report is shown in Excel with all grids shown as per normal?