[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 955
  • Last Modified:

Crystal reports 8 spooling slowly on Windows Xp PC

Hi all,

this is a repost of a question i posted earlier this month to the hardware section  (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/XP/Q_23434435.html).

Explanation of problem:
Windows Xp Machine, running Crystal reports 8, SQL Server 2000

We Have a Label (printed ona Zebra Z4M printer) which gets it's data from a stored procedure in a SQL Server 2000 database.  This label looks at one table and prints labels based on the criteria in the stored procedure.

We've noticed in Windows XP that the spooling of the label from Crystal to the printer (via LPT1) has slowed up dramatically.  Initially the problem manifests itself with gridlines on the label not printing using Zebra version 2.4 driver.  I have tried using Seagull Scientific Drivers and Nice Drivers, when i use these drivers, the gridlines re-eppear but the spooling slows dramatically.

I can absolutley say it is not the printer as i have created a blank label with no database lookup and speed is perfect.

I can say that the issue is not with the SQL Server stored procedure/table as I have deleted every record in the table and re-inserted 5 rows to print but the issue still occurs.

If i change operating System to Windows 2000 no issue occurs, be it with speed or gridlines not appearing, everything is perfect.

Any help is very much appreciated.
0
StiggySon
Asked:
StiggySon
  • 5
  • 3
1 Solution
 
mlmccCommented:
The problem is your graphics.  Since you are printing the gridlines, Crystal prints the entire label in graphics mode 1 pixel at a time.

mlmcc
0
 
StiggySonAuthor Commented:
Would this expalin the difference between windows xp and 2000 and what (if any) is the workaround
0
 
mlmccCommented:
It could.  Can you install the Win2K printer driver on the XP machne?

mlmcc
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
StiggySonAuthor Commented:
yeah i've done that, the gridlines on the label disappear then, speed wise it's normal but with no gridlines the label is useless
0
 
mlmccCommented:
It could be the XP driver is doing the entire label in graphics mode but the 2000 driver is able to switch between text and graphics as needed.

mlmcc
0
 
StiggySonAuthor Commented:
We have found that Clients running Windows 2000 in some of our remote sites do not have this issue, the chageover to Windows XP is affecting the rate at which the labels get spooled (printing speed is not affected).
0
 
StiggySonAuthor Commented:
purchasing a new printer with SUB support and dedicated windows xp drivers resolved the issue
0
 
StiggySonAuthor Commented:
Crystal reports 8 ins't supported on Windows Xp, the first verion of Crystal with Xp support is version 9.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now