GridLines problem when exporting a report to excel

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.

Hello Kamii,

#1. Can you verify that your BorderColor is not set to White and your BorderStyle is set to Solid on your textboxes in your report?

#2. Here's the example MS had, but changed to Excel: http://servername/reportserver?/Sales/YearlySalesSummary&rs:Format=EXCEL&rs:Command=Render

This link explains the URL export. http://msdn2.microsoft.com/en-us/library/ms154040.aspx
Here's another link for Using URL Access Parameters: http://msdn2.microsoft.com/en-us/library/ms152835.aspx

Hope this helps.

Jarret

|||Thanks Jarret
I have one more question

3,
We have predefined excel tempaltes
I 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 it
Can you please refer me from where i can find help regarding this ?
|||

I don't think this will be possible with Reporting Services. Here are a few posts from others that are wanting to use templates as well.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=519081&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=461709&SiteID=1

The second link above mentions a third party tool that looks like it will do what you need.

http://officewriter.softartisans.com/officewriter-250.aspx

Jarret