Batch Printing Crystal reports from VB.Net application
- From: rock <rratterree@xxxxxxxxx>
- Date: Thu, 02 Aug 2007 11:52:22 -0700
I have a vb.net application that reads a directory to get a list of
xml files that were generated by a third party app. Each xml file
contains the data for a different order and is routed to a different
printer that was predetermined and stored as one of the entries in the
xml file. My application opens the xml file, gets the printer id, a
couple of other pieces of information, and then binds the xml data to
a crystal report, and prints the report to the specified printer.
We're talking over 200 different printer id's across 2 states, and
thousands of orders a day.
My problem is that it's relatively slow...according to our users
anyway. It can take anywhere from 2 seconds ( which isn't bad at all
if you ask me) up to 20 seconds to print to the actual printer. The
bottleneck is that if someone prints 200 orders at one time, each of
those have to print before someone somewhere else can print their one
or two orders. I know that network traffic, printer hardware, and
other variables affect performance, but my users want me to work
beyond that (of course they do).
Here's my question. Is there a way to get my vb.net application to
move on after it has spooled the report instead of waiting for it to
print successfully ( or not and catch the exception). I have tried
exporting the reports to disk as *.pdf and *.doc files, and then
copying the files to the print server as a preformatted document.
That didn't get me much in terms of performance, and it doesn't seem
to work on every printer, as some printers only printed garbage. I
thought since the documents were already preformatted, that it
wouldn't need a special print driver to handle the generic document
type, but I was obviously wrong in making that assumption. My thought
was compiling the reports by printer and then doing a mass copy, but
vb.net still waits for each report to print before copying the next.
And then there's still the garbage out issue ( even though it's good
going in, I promise).
Our printers are 99% HP although we're looking at several other
brands, so that can only complicate matters. It would be nice if
everyone used the same high performance printers, but a lot of our
users are "limited" in what they can spend, but still want high
performance. It's like buying a yugo and expecting your mechanic to
make it work like a lamborghini...it just ain't gonna happen!
Oh, I forget, there's been an edict issued from the top down that
we're not getting any new software for the rest of 2007 or 2008. So,
I really need a .net whiz here and not a vendor.
Thanks for any and all suggestions.
Rock
.
- Prev by Date: Crystal Reports for Visual Studio 2005 error in Managed Assembly, HELP!
- Next by Date: Re: Visible in preview, not while printing
- Previous by thread: Crystal Reports for Visual Studio 2005 error in Managed Assembly, HELP!
- Next by thread: Re: Visible in preview, not while printing
- Index(es):
Relevant Pages
|