The user can download one order or a range of orders to print. The
download process loads the local tables and builds the report.
Currently it takes 56 steps to build our order reports. We do a lot of
unique custom stuff that requires so many steps. It is very efficient.
Our Vantage DB had 65834 order lines and the download to print one
order took 1.5 seconds.
I can send you the Access Database that prints our Order
Acknowledgements if you want to take a look at it.
download process loads the local tables and builds the report.
Currently it takes 56 steps to build our order reports. We do a lot of
unique custom stuff that requires so many steps. It is very efficient.
Our Vantage DB had 65834 order lines and the download to print one
order took 1.5 seconds.
I can send you the Access Database that prints our Order
Acknowledgements if you want to take a look at it.
--- In vantage@yahoogroups.com, "rstulce" <rstulce@...> wrote:
>
> How to you keep the Access DBs in synch with the Vantage DB?
>
>
>
> Thanks,
>
> Randy
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> rom_lawiksell
> Sent: Thursday, February 15, 2007 8:13 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Reporting
>
>
>
> I, we at ROM, gave up on Crystal two years ago. Our quotes, orders
and
> invoices required more detail so our custom Crystal reports ended
up
> with 8 subreports. It took 16 minutes to print an invoice. We
> switched to Access. Now our invoices print in less than 10 seconds.
> We print our production schedule, packing slips, shipping labels
and
> much more with Access. In fact we have about 40 Access databases
> running now which gives us faster and better control over how we
want
> our reports printed. I hated working with Crystal and have found
> Access much much better.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>