At 02:48 pm 13/3/1999 +1300, Tony Blomfield said:
>Hi Steve. Long time no speak.
Very long. Good to catch up with you. I too abandoned the list for a long
while and only just came back.
>Re Crystal, so nothing has really changed has it. Of course this means that
>Crystal is disgustingly slow at running any reports, and network traffic is
>maximised.
Definately. I thought it was a real show stopper in a couple of cases. When
I first reported it to this group, I suggested that an unsuspecting report
can pull the whole server down.
e.g. boss says "OI You! give me a list of everyone who hasn't given us
their city they live in then!, Oh, and let me know all their transaction
history and any other details we have on them both here and in Australia
so's I can figure out where they're from then."
As you may imagine, unsuspecting programmer, whips up a beaut little
crystal report that queries 1 million people here and 5 million in Aussie
looking for only those tiny few who didn't say where they lived. The same
query then gets all the transaction history, telephone messages, sales
calls, repair history etc.
Thinking it'll list about half a dozen people, the poor sod probably has to
wait 5 days before he's proved right. In the meantime, no user in any
office throughout Australasia is able to access either the database or
their network due to congestion. Poor sod is walking sadly down street
rubbing boot print off trousers after the end of day 1.
That query will not just get the 6 million records, it'll also get every
record from every database the master is attached to (transaction history
etc).
>To me, I found the learning curve with crystal quite steep for many of my
>customers, so what product would you reccomend for end users?
"Nifty telephone-number-direct-to-Development-team" version 1.0
Other than that, I dunno. Trying to find the Report Builder Pro, Alta-Vista
turned up "ReportPrinter Pro" which seems to have a nifty end user report
builder. That may help.
Steve
__________________________________________________________________
|Steve Peacocke ([EMAIL PROTECTED])
| http://trader.co.nz/
| also, trader.co.nz/vizsla/ & trader.co.nz/vizsla/docking
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
