Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Crystal reports 8 spooling slowly on Windows Xp PC

Posted on 2008-06-11
8
Medium Priority
?
950 Views
Last Modified: 2009-12-16
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
Comment
Question by:StiggySon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 21761261
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
 

Author Comment

by:StiggySon
ID: 21769209
Would this expalin the difference between windows xp and 2000 and what (if any) is the workaround
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 21771719
It could.  Can you install the Win2K printer driver on the XP machne?

mlmcc
0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 

Author Comment

by:StiggySon
ID: 21773258
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
 
LVL 101

Accepted Solution

by:
mlmcc earned 1500 total points
ID: 21775414
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
 

Author Comment

by:StiggySon
ID: 21791826
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
 

Author Comment

by:StiggySon
ID: 21828902
purchasing a new printer with SUB support and dedicated windows xp drivers resolved the issue
0
 

Author Comment

by:StiggySon
ID: 21846314
Crystal reports 8 ins't supported on Windows Xp, the first verion of Crystal with Xp support is version 9.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question