Embedded image export into PDF

Question

Hi,

I have an application form that needs to be embedded into three pages report and exported into PDF for printing. When I import the image, it appears in a much larger size, so I have to resize it manually to fit it into one page. There are two issues here. When I export the file into PDF format, I have three full pages as well as three empty pages and I can't remove them from the report. Secondly, quality of the embedded image is downgraded when I export it to PDF format.

We are using SQL 2005 Report server.

Thanks

DK DBA

Answer 1

Hi DK,

From your description, you get some extra blank pages after you export report to PDF, right? This is almost always caused by the Body of your report being too wide for your page. Make sure that the Width of the Body is less than the physical page size, less the margins. Here has a blog about extra blank page, please see:
http://blogs.msdn.com/b/chrisbal/archive/2006/08/10/694892.aspx

And the quality of the embedded image is downgraded, this issue may be caused by that you have resize the images. For more information, please see:
Question14 "How to improve PDF quality of the report exported in Reporting Services 2005" in the following FAQs:
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/48de91f9-1844-40c1-9614-5ead0b4b69a5
Another similar thread for your reference:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1e29b4b3-3cb8-4f46-a89f-839089665b0f/

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support

Answer 2

Thanks very much Charlie,

I resized the body and that helped eliminate empty pages. For the issue with image quality, I am a bit confused to where Bitmap.SetResolution is modified? Does anyone know any details about it?

Thanks

Dragana