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

Gridlines in excel

We currently using reporting services to generate excel reports. I was unable
to switch on gridlines for my excel reports and reverted to the method where
I gave each cell a border to simulate gridlines.
These 'styles' prove to be problematic, especially with large spreadsheats.
I have a large 47MB spreadsheet which takes a few minutes to load. By
replacing the cell borders with gridlines and resizing the cells the size
drops to 36MB and it loads instantaniously.
How can I generate excel reports with gridlines 'switched on' by default.Not possible to enable grid lines from RS for excel, may be after excel is
created you can enable it by going to tools ->options->view click on check
box for gridlines. But I dont think you require like this to do that too each
and every users?
Amarnath, MCTS
"JRMalherbe" wrote:
> We currently using reporting services to generate excel reports. I was unable
> to switch on gridlines for my excel reports and reverted to the method where
> I gave each cell a border to simulate gridlines.
> These 'styles' prove to be problematic, especially with large spreadsheats.
> I have a large 47MB spreadsheet which takes a few minutes to load. By
> replacing the cell borders with gridlines and resizing the cells the size
> drops to 36MB and it loads instantaniously.
> How can I generate excel reports with gridlines 'switched on' by default.