March 27, 2009 at 1:27 pm
I have a report with some high resolution(JPEG) images. when printing from Report Manager reports prints very slowly. We have tried BMP images, which seem to print even slower. We have also used the Report Viewer control in an application and printing is also slow. If we export the report to PDF and then print the print is fast. Does anyone have any ideas of what is going on???
Curtis Smith
SQL Server DBA
Well in worked in Theory ...
April 3, 2009 at 12:33 pm
What is slow about the printing? Is it the time it take the first page to come out, the entire job, does it go for a few pages then stop? Most likely it is because the images you are using are HUGE. Check and see how large your print job is in the print spooler next time you print it. It's probably many MB. Check the size when you print it via pdf, probably much smaller
Remember reports printed using the RSClientPrint.DLL are basically just printed as images. If you export them to PDF they go through a different rendering engine which may compress your images down to a reasonable size.
To speed things up you can try playing with the print spooler properties. !st make certain it's set to Spool so that application finishes printing fast. Also make certain you have start printing immediately. Perhaps set to send directly to printer may help, but it's doubtful.
Hopefully that will get you moving in the right direction. But the real answer is probably dropping the resolution of the original images.
-Luke.
April 6, 2009 at 5:57 am
This is a known issue with reporting services. We had to change the code to go directly to PDF. and then print from there.
Curtis Smith
SQL Server DBA
Well in worked in Theory ...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply