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?
Best Answer
There is some Technet information on the intended behaviour of the export: https://technet.microsoft.com/en-us/library/dd255234(v=sql.105).aspx