Wednesday, March 7, 2012

Reducing the PDF File Size

Hi all.

I'm using MS SQL 2000's Reporting Services. Our output PDFs are usually composed of fifteen or more pages. Our file size typically exceeds 2 MB per report, I was testing the report on sample outputs and I was getting around 40kb per chart and each of our pages are typically composed of 2-3 charts.

Is there a tweak that can be applied to reduce the file size of the output pdf?

Thanks,
EdwardDO you have any images rendered into the report ? As the report is based on Adove 4 definitions its limitated to the rendering compressions.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de|||Yes there are images, from the outputs I've generated that does not include any chart the file size is significantly smaller around 8kb per page. The majority of the file size is made up of the charts themselves.

Are you saying that the file size increase caused by the charts cannot be reduced any further due to rendering compressions?|||I guess this is probably the case. WHich version / SP are you currently running ? Ther ehvae been some iprovements on the Reporting rendering during the history of the Service pack development.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||The version I am currently running on the server is:

8.0.1038.0

What service pack version does this belong to?

Thanks.|||Thats the most recent service pack, its service pack 2. SOrry, but there are no more other tweaks that come in my mind. We once had the problem that images (blobs) from the database weren′t compressed properly, because the rendering mechanism could not handle the images in a right way, this was fixed in a Service Pack (I think is was service pack 2)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211

No comments:

Post a Comment