Answered by:

GridLines problem when exporting a report to excel

Question

1, I have a report when I export it to excel it exported successfully. But when I open the report the grid lines are gone. I have to manually enable grid lines to view them. How Can I export the file to excel such that grid line will be enable

2,Currently I am checking the export to excel via report manager. What should be the url to export to excel.

Thanks JarretI have one more question3,We have predefined excel tempaltesI have a excel report with on main worksheet all data then on other work sheet data based on first work sheet with pivot table.We were generating with old vb6 application.Now I want's to use SSRS to generate report then export it to excel as my previous template.Can i do that ?

I know it is an odd idea by the client but we have to implement itCan you please refer me from where i can find help regarding this ?

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.....