Advice Required

[Robert Edis]

Robert

If you are setting up a new reporting environment I suggest you move to
either Impromptu, CRN or Cognos 8 BI (Report/Query Studio) for ad-hoc
reporting rather than Quiz.

Blue

--------------------------------------------------------------------------
Just after sending my original post I realised that my request was too
vague. Here is another go.

Having never used Quiz in a Client/Server environment I'm in need of
advice on which direction to go.

A) We could have Quiz on the Unix/Oracle box using cron (or something
similar) to run the production reports. Question is how would the users
interact with it from their Windows/Desktop (ad-hoc reports)?

B) We could have Quiz on the Windows/Desktop accessing Oracle via ODBC
(or something similar) to run the ad-hoc reports. Question is how and
where do we run the production reports? Shouldn't they be run on the
Unix/Oracle box?

C) Should we go Axiant? That would work OK for the ad-hoc reports but
what about the production reports?

D) Is there a different way to do it or do we require a combination of
the above three options?

E) Can database views be used by Quiz (in a Cursor?)?

F) Anything else you might think of that can trip us up <G>.

As you can see, lots of question and no answers (yet).


regards,

Robert W.Mills
MIS Systems Development Manager
Windsong Services
+44 (0)20 8309 3604