Export to Excel Show GridLines
-
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 (4/20/2009)
HiI 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
:w00t:Does anyone have a solution to this issue with Reporting Services
-
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.
"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
-
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.
-
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.
"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
-
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
-
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply