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