SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Export to Excel Show GridLines


Export to Excel Show GridLines

Author
Message
rahulwalawalkar
rahulwalawalkar
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 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



rahulwalawalkar
rahulwalawalkar
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 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
:w00tBigGrinoes anyone have a solution to this issue with Reporting Services



Siva Gurusamy
Siva Gurusamy
Old Hand
Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)

Group: General Forum Members
Points: 331 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
rahulwalawalkar
rahulwalawalkar
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 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.



Siva Gurusamy
Siva Gurusamy
Old Hand
Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)

Group: General Forum Members
Points: 331 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
nlaslett
nlaslett
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 84
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
Alex Thomas-253121
Alex Thomas-253121
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search