Re: Advice on reporting on Oracle

From: Paul Osborn <posborn_at_ix.netcom.com>
Date: 1995/09/07
Message-ID: <42nf2a$icq_at_ixnews5.ix.netcom.com>#1/1

>Frans-Willem van der Velden (fvelden_at_intersun.gak.nl) wrote:
>
>: Internetters and Oracle-gurus,
 

>: What tool or tools would you use if :
 

>: You were asked to do reporting on an oracle database on the vax/vms
 platform
>: with the need for scheduled standard reporting and very user
 friendly ad hoc
>: reporting.
 

>: The user wants to be as independant of IS as possible, does not want
 to
>: understand sql and relational schema's.
 

>: What would you use????
 

>: Greetings,
 

>: Frans-Willem van der Velden :-)
 

>: - Due to computers one can make mistakes faster -

If the users have PCs look at MS-Access.

1) You backend it to Oracle via ODBC [pain to set up & slow].
2) [Optional] Create several views to ease user report creation.
3) Create a role/user w/select access only to the underlying data

structures.
4) Let the users generate their own reports w/the Access cut and paste facilities [easy to learn for the computer literate].

Advantages:

1) Cheap
2) Easy to learn for the computer literate.
3) Gets you away from generating "mailing labels..." ad nauseam.
4) Part of the MS family of products [debateable advantage].

Received on Thu Sep 07 1995 - 00:00:00 CEST