Friday, March 30, 2012
reporting services TOC
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"mike" <michael.w.i@.gmail.com> wrote in message
news:dbd5909c.0411121733.623da7b3@.posting.google.com...
> We need a way add a WORD style TOC to a report, an ideas out there...?sql
Reporting Services to MS Word Questions
I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.
The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.
Is there a way to fix this formatting issues in Word?
Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||
We have the same dillemma...
We are currently evaluating another reporting tool due to couple of reasons:
1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.
2) No support for export of nested data regions to Excel?
Any idea when these features will be available?
Thanks a lot,
Panna Balaji
|||We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.
Reporting Services to MS Word Questions
I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.
The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.
Is there a way to fix this formatting issues in Word?
Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||
We have the same dillemma...
We are currently evaluating another reporting tool due to couple of reasons:
1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.
2) No support for export of nested data regions to Excel?
Any idea when these features will be available?
Thanks a lot,
Panna Balaji
|||We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.
Reporting Services to MS Word Questions
I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format.
The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word.
Is there a way to fix this formatting issues in Word?
Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment.
Thanks in advance for the help!We currently do not have a native export into Microsoft Word format. It is high on our list for a post-SQL 2005 release. You might take a look at SoftArtisans, a 3rd party that provides this functionality, http://officewriter.softartisans.com/officewriter-250.aspx.|||Is there any estimated date when a patch or release of SQL RS will be available that exports directly to Word format? This effects our decision and how we will view costs.|||
We have the same dillemma...
We are currently evaluating another reporting tool due to couple of reasons:
1)Mainly because SQL Server RS does not support direct export to MS Word /RTF.
2) No support for export of nested data regions to Excel?
Any idea when these features will be available?
Thanks a lot,
Panna Balaji
|||We have developed and just released Aspose.Words for Reporting Services that is currently the only solution available for exporting any RDL report to true DOC, RTF and WordML.
Wednesday, March 7, 2012
Reporting Services export to Excel
does anyone know of a way to export a RS file into Excel and
automatically turn off the the word wrap? Otherwise, the cells get
clipped. Has anyone seen this before?I don't know if this will work or not, but try playing with the Can
Grow, Can Shrink properties.
If that doesn't work, I don't think there will be any other way.
--
Regards
Chris
krister tidics | FOX IT wrote:
> Hey -
> does anyone know of a way to export a RS file into Excel and
> automatically turn off the the word wrap? Otherwise, the cells get
> clipped. Has anyone seen this before?