I was wondering how everyone (if anyone) is exporting reports to Word? Does
anyone know of an open source attempt at this or even one that is only a few
hundred bucks?
Thanks
ScottHello Scott,
The Reporting Services does not support the Word Extension. You need to
develop the custom extension.
I would like to provide an article which used for Reporting Services 2005
and Office 2007. In this article, the author create a component which makes
you could export the report to a word document.
Designing and Delivering Rich Office Reports with SQL Server Reporting
Services 2005 and SoftArtisans OfficeWriter
http://msdn2.microsoft.com/en-us/library/aa964136.aspx
Hope this will be some help for you.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||That's the component that I was looking at, but it's VERY expensive!
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:HE%23aMMDGHHA.2304@.TK2MSFTNGHUB02.phx.gbl...
> Hello Scott,
> The Reporting Services does not support the Word Extension. You need to
> develop the custom extension.
> I would like to provide an article which used for Reporting Services 2005
> and Office 2007. In this article, the author create a component which
> makes
> you could export the report to a word document.
> Designing and Delivering Rich Office Reports with SQL Server Reporting
> Services 2005 and SoftArtisans OfficeWriter
> http://msdn2.microsoft.com/en-us/library/aa964136.aspx
> Hope this will be some help for you.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Wow - $1500 for a component to export into word (ultimately anyway).
Why did MS never implement it? I mean, with SP2 just released for all SQL
2005 products, it would have been the perfect opportunity.
"Scott M" <scott_M@.nospam.nospam> wrote in message
news:uzVlWyEVHHA.4832@.TK2MSFTNGP04.phx.gbl...
> That's the component that I was looking at, but it's VERY expensive!
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
> news:HE%23aMMDGHHA.2304@.TK2MSFTNGHUB02.phx.gbl...
>> Hello Scott,
>> The Reporting Services does not support the Word Extension. You need to
>> develop the custom extension.
>> I would like to provide an article which used for Reporting Services 2005
>> and Office 2007. In this article, the author create a component which
>> makes
>> you could export the report to a word document.
>> Designing and Delivering Rich Office Reports with SQL Server Reporting
>> Services 2005 and SoftArtisans OfficeWriter
>> http://msdn2.microsoft.com/en-us/library/aa964136.aspx
>> Hope this will be some help for you.
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>> Note: The MSDN Managed Newsgroup support offering is for non-urgent
>> issues
>> where an initial response from the community or a Microsoft Support
>> Engineer within 1 business day is acceptable. Please note that each
>> follow
>> up response may take approximately 2 business days as the support
>> professional working with you may need further investigation to reach the
>> most efficient resolution. The offering is not appropriate for situations
>> that require urgent, real-time or phone-based interactions or complex
>> project analysis and dump analysis issues. Issues of this nature are best
>> handled working with a dedicated Microsoft Support Engineer by contacting
>> Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>> ==================================================>> (This posting is provided "AS IS", with no warranties, and confers no
>> rights.)
>|||On Feb 19, 10:25 pm, "Immy" <therealasianb...@.hotmail.com> wrote:
> Wow - $1500 for a component to export intoword(ultimately anyway).
> Why did MS never implement it? I mean, with SP2 just released for all SQL
> 2005 products, it would have been the perfect opportunity.
> "Scott M" <scot...@.nospam.nospam> wrote in message
> news:uzVlWyEVHHA.4832@.TK2MSFTNGP04.phx.gbl...
>
> > That's the component that I was looking at, but it's VERY expensive!
> > "Wei Lu [MSFT]" <w...@.online.microsoft.com> wrote in message
> >news:HE%23aMMDGHHA.2304@.TK2MSFTNGHUB02.phx.gbl...
> >> Hello Scott,
> >> TheReportingServicesdoes not support theWordExtension. You need to
> >> develop the custom extension.
> >> I would like to provide an article which used forReportingServices2005
> >> and Office 2007. In this article, the author create a component which
> >> makes
> >> you could export the report to aworddocument.
> >> Designing and Delivering Rich Office Reports with SQL ServerReporting
> >>Services2005 and SoftArtisans OfficeWriter
> >>http://msdn2.microsoft.com/en-us/library/aa964136.aspx
> >> Hope this will be some help for you.
> >> Sincerely,
> >> Wei Lu
> >> Microsoft Online Community Support
> >> ==================================================> >> Get notification to my posts through email? Please refer to
> >>http://msdn.microsoft.com/subscriptions/managednewsgroups/default.asp...
> >> ications.
> >> Note: The MSDN Managed Newsgroup support offering is for non-urgent
> >> issues
> >> where an initial response from the community or a Microsoft Support
> >> Engineer within 1 business day is acceptable. Please note that each
> >> follow
> >> up response may take approximately 2 business days as the support
> >> professional working with you may need further investigation to reach the
> >> most efficient resolution. The offering is not appropriate for situations
> >> that require urgent, real-time or phone-based interactions or complex
> >> project analysis and dump analysis issues. Issues of this nature are best
> >> handled working with a dedicated Microsoft Support Engineer by contacting
> >> Microsoft Customer SupportServices(CSS) at
> >>http://msdn.microsoft.com/subscriptions/support/default.aspx.
> >> ==================================================> >> (This posting is provided "AS IS", with no warranties, and confers no
> >> rights.)- Hide quoted text -
> - Show quoted text -
Check out Aspose.Words for Reporting Services that we have just
released:
http://www.aspose.com/Products/Aspose.WordsRS/
It is a true rendering extension for Microsoft SQL Server 2005
Reporting Services that adds export to DOC, RTF and WordprocessingML.|||Why is "export to Word" not built into report services?
Showing posts with label export. Show all posts
Showing posts with label export. Show all posts
Wednesday, March 7, 2012
Friday, February 24, 2012
Chart to WORD
How to export chart to word.Please help me.
Would copy paste from report manager be good enough?|||Thanks for your suggestion Adam.But I can't tell this to my client.Is there any another method
|||Then your other options are SoftArtisans OfficeWriter for Reporting Services http://officewriter.softartisans.com/download/ds_ReportingServices.pdf
Or writing your own Rendering Extension.
Reporting Services only supports export to excel out the box.
Chart Resolution in PDF
When I export reports with charts to PDF, the server really takes a beating
and the resulting PDF file can get quite large. We would like to reduce the
resolution of the chart images that are being embedded in the PDF and/or
reduce the resolution of the PDF itself.
The help topic "Designing for PDF Output"
(ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsrvr9/html/e266ff64-ce8e-427d-980d-a93c6a069b7d.htm)
mentions that the resolution of the PDF can be configured in device settings,
but the PDF Device Settings help topic does not mention any setting like this
(nor does the Image Device Settings help).
Any input is appreciated.
ScottI have been tracking down an answer to this question as well.
It looks like in older versions you could set the DpiX and DpiY. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_8bld.asp
But this is not an option for SQL 2005. See
http://msdn2.microsoft.com/en-us/library/ms154682(SQL.90).aspx
If you find anything else that will prove this wrong, please post. Thanks!
"ScottB" wrote:
> When I export reports with charts to PDF, the server really takes a beating
> and the resulting PDF file can get quite large. We would like to reduce the
> resolution of the chart images that are being embedded in the PDF and/or
> reduce the resolution of the PDF itself.
> The help topic "Designing for PDF Output"
> (ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsrvr9/html/e266ff64-ce8e-427d-980d-a93c6a069b7d.htm)
> mentions that the resolution of the PDF can be configured in device settings,
> but the PDF Device Settings help topic does not mention any setting like this
> (nor does the Image Device Settings help).
> Any input is appreciated.
> Scott|||We believe the problem is caused by defects in the 64-bit version of SQL
2005. When we moved back to 32-bit, this (and other) anomalies disappeared.
Scott
"shelley" wrote:
> I have been tracking down an answer to this question as well.
> It looks like in older versions you could set the DpiX and DpiY. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_8bld.asp
> But this is not an option for SQL 2005. See
> http://msdn2.microsoft.com/en-us/library/ms154682(SQL.90).aspx
> If you find anything else that will prove this wrong, please post. Thanks!
> "ScottB" wrote:
> > When I export reports with charts to PDF, the server really takes a beating
> > and the resulting PDF file can get quite large. We would like to reduce the
> > resolution of the chart images that are being embedded in the PDF and/or
> > reduce the resolution of the PDF itself.
> >
> > The help topic "Designing for PDF Output"
> > (ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsrvr9/html/e266ff64-ce8e-427d-980d-a93c6a069b7d.htm)
> > mentions that the resolution of the PDF can be configured in device settings,
> > but the PDF Device Settings help topic does not mention any setting like this
> > (nor does the Image Device Settings help).
> >
> > Any input is appreciated.
> >
> > Scott
and the resulting PDF file can get quite large. We would like to reduce the
resolution of the chart images that are being embedded in the PDF and/or
reduce the resolution of the PDF itself.
The help topic "Designing for PDF Output"
(ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsrvr9/html/e266ff64-ce8e-427d-980d-a93c6a069b7d.htm)
mentions that the resolution of the PDF can be configured in device settings,
but the PDF Device Settings help topic does not mention any setting like this
(nor does the Image Device Settings help).
Any input is appreciated.
ScottI have been tracking down an answer to this question as well.
It looks like in older versions you could set the DpiX and DpiY. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_8bld.asp
But this is not an option for SQL 2005. See
http://msdn2.microsoft.com/en-us/library/ms154682(SQL.90).aspx
If you find anything else that will prove this wrong, please post. Thanks!
"ScottB" wrote:
> When I export reports with charts to PDF, the server really takes a beating
> and the resulting PDF file can get quite large. We would like to reduce the
> resolution of the chart images that are being embedded in the PDF and/or
> reduce the resolution of the PDF itself.
> The help topic "Designing for PDF Output"
> (ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsrvr9/html/e266ff64-ce8e-427d-980d-a93c6a069b7d.htm)
> mentions that the resolution of the PDF can be configured in device settings,
> but the PDF Device Settings help topic does not mention any setting like this
> (nor does the Image Device Settings help).
> Any input is appreciated.
> Scott|||We believe the problem is caused by defects in the 64-bit version of SQL
2005. When we moved back to 32-bit, this (and other) anomalies disappeared.
Scott
"shelley" wrote:
> I have been tracking down an answer to this question as well.
> It looks like in older versions you could set the DpiX and DpiY. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_8bld.asp
> But this is not an option for SQL 2005. See
> http://msdn2.microsoft.com/en-us/library/ms154682(SQL.90).aspx
> If you find anything else that will prove this wrong, please post. Thanks!
> "ScottB" wrote:
> > When I export reports with charts to PDF, the server really takes a beating
> > and the resulting PDF file can get quite large. We would like to reduce the
> > resolution of the chart images that are being embedded in the PDF and/or
> > reduce the resolution of the PDF itself.
> >
> > The help topic "Designing for PDF Output"
> > (ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsrvr9/html/e266ff64-ce8e-427d-980d-a93c6a069b7d.htm)
> > mentions that the resolution of the PDF can be configured in device settings,
> > but the PDF Device Settings help topic does not mention any setting like this
> > (nor does the Image Device Settings help).
> >
> > Any input is appreciated.
> >
> > Scott
Subscribe to:
Posts (Atom)