Pause between pages when printing RS report
I am using Report Services on SQL Server 2005. I have a report that gets its data from a single SQL Server stored procedure. One other small table is used, but only to provide a list of values for selecting a parameter value to send to the stored procedure.On the report I use a list control to display multiple records per page.When printing the report (which currently produces over 500 pages - future printings of this report will not be nearly so large), the printer pauses between each page as if they are seperate print jobs. This is an HP LaserJet 5Si that normally cranks out reports very fast.The only thing I can think of that might contribute to this sort of behavior is the fact that I set my margin sizes to 0in to get as much design room on the report as possible. Could that cause this sort of behavior?
November 14th, 2005 6:42pm

Just bumping this topic. I'm very much in need of an answer on this. I've tried different settings for the margins as well, but anything other than 0in. causes extra pages to be printed.How can I eliminate the pause between pages?
Free Windows Admin Tool Kit Click here and download it now
December 7th, 2005 11:00pm

How are you printing the report? Are you using the printing via the web or using delivery? I have not heard of this sort of behavior. The only thing I can think of is that the server is busy rendering each page and is causing the printer to wait for additional pages.-Daniel
December 8th, 2005 1:26am

Thanks for the reply.I am printing the reports via the web. This behavior is exhibited when printing them from the Visual Studio design environment as well.
Free Windows Admin Tool Kit Click here and download it now
December 8th, 2005 4:58pm

Most likely, your printer is able to print faster than the ability of the server to generate the pages. This could happen if the pages are complex and/or have lots of images. The overall time should be similar to exporting the report to an image format.
December 8th, 2005 9:17pm

I guess I can see where the report generation might be the bottleneck, however it is just a standard report with a basic list control displaying some 20-25 data fields per record. There are no images being used at all. The most graphically intensive element is a light gray filled box around the report title.Honestly, I can't imagine a much simpler report. That is why I have trouble accepting this as being as good as it gets.
Free Windows Admin Tool Kit Click here and download it now
December 8th, 2005 10:18pm

The fact that you see this in the designer as well as the server seems to mean that the issue may lie elsewhere. Do any other reports behave this way? Are you able to try any other printers?When you print from the web you can preview the report first. Can you first preview the entire report before printing? By doing this you will have downloaded all the pages to the client, when you actually print you will just be sending the emf file to the printer. If the problem still occurs then it is most likely an issue downstream from RS if it doesn't occur then RS would have some issue.Thanks.-Daniel
December 8th, 2005 10:22pm

This behavoir can be caused by your printer. Often an inkjet printer (all brands) will pause for ink drying time between pages to make sure the ink does not smear between sheets. However, being a laserjet, I wonder if you have the correct driver set. I doubt the margins or anything in the document causes the problem. Here is another possibility: when a large document with illustrations is printing, the pagination may be recalculated between each page as a page is sent to the printer. Try printing just the last 2 pages of the document (Print: 499 - 500). If it is printed fast, you can suspect something in the output processing-like repagination. Try the same with the first 2 pages (Print: 1-2). This will give you a clue to the issue. An easy solution is to the repagination issue is to position the document to the final page (display the last page and place the cursor in that page) when you prepare to print...or just force or stop repagination prior to printing (in the advance options).
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2010 2:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics