Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Export to Excel Show GridLines Expand / Collapse
Author
Message
Posted Monday, April 20, 2009 7:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 7, 2010 6:55 AM
Points: 19, Visits: 124
Hi

I am exporting report using Report Manager from SSRS 2005 ,Export format is excel one I export and open the report,I don't ssee any grildines in the exported repot can you lrt me know how can i do that.
Rahul



Post #700618
Posted Wednesday, April 22, 2009 2:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 7, 2010 6:55 AM
Points: 19, Visits: 124
rahulwalawalkar (4/20/2009)
Hi

I am exporting report using Report Manager from SSRS 2005 ,Export format is excel one I export and open the report,I don't ssee any grildines in the exported repot can you lrt me know how can i do that.
Rahul
Does anyone have a solution to this issue with Reporting Services



Post #702129
Posted Thursday, April 23, 2009 10:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
Look for properties:

border color, set it to black and
border style set it to solid

Try for table properties if that does not work, then set the same properties for column.
You should be solid grid lines in excel.





View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #703389
Posted Friday, April 24, 2009 1:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 7, 2010 6:55 AM
Points: 19, Visits: 124
Hi Siva,

I have done that already ,it works fine just for the Table Data Part which has gridlines,when exported to excel, but rest of the excel worksheet does not show GridLines.........Is their a way in SSRS 2005 we can show GridLines for the remaining worksheet which is not rendered as Table Data Part.

I never had such issue when exporting to excel using Crystal Reports.



Post #703773
Posted Friday, April 24, 2009 8:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 4, 2010 10:17 AM
Points: 191, Visits: 386
Sorry Rahul.

do you want gridlines on cells, say that is a header (textbox in the report) or do you want headlines outside of the region occupied by the report in Excel.

If it the former, setting style and color in all controls will give you solid grid lines. If it the later then I am sorry. Please let me know if you get to know how.





View Siva Gurusamy's profile on LinkedIn

"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Post #703989
Posted Tuesday, July 7, 2009 8:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 9:58 AM
Points: 5, Visits: 79
The original poster is correct: When you create a file through some external means and save it as a .xls file, by default "Show Gridlines" is turned off. This means that your data appears on a plain white background. You can manually turn on gridlines (Tools >> Options >> View >> Gridlines), but most users won't know how to do that (or won't think of it).

Anybody know if there is a way to do this programmaticly?

Yes, of course you can slap literal borders on your grid, but that just adds to the original problem: You still have gridlines turned off, but now you also have a bunch of formatting all over your cells. I'm trying to avoid that.

In my case, I am exporting the sheet from HTML via a dynamic script. The data is in a no-frills table, and I set the MIME type to application/vnd.ms-excel. Works great, except for this one problem.

Neil
Post #748619
Posted Wednesday, January 20, 2010 6:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 21, 2010 7:17 PM
Points: 1, Visits: 10
Options include:

- Embedding advice in the report for users that gridlines can be enabled using the 'Tools - Options - View - Gridlines' option
- Using built-in report formatting, such as cell borders or alternating background colours of lines or sets of lines (banding) (This will only format the data area)
- Enhancing the CRT with a third-party Excel renderer that employs Excel templates (eg SoftArtisans OfficeWriter, Aspose.Cells
Post #850936
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse