Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: question on oracle to combine with reports software

Re: question on oracle to combine with reports software

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 24 Feb 2003 11:56:13 -0800
Message-ID: <3E5A78DD.A699E19@exesolutions.com>


j wrote:

> Hi all ,
>
> I am now working in a company and they are using crystal report with
> oracle database. They told me not to draw data directly from all tables into
> the report. Rather, on application level, they trigger a stored proc to
> insert all the retrieved data into another "tailor made" table for report
> and then forward to crystal report to draw the data from the table. They
> said that they can customize the logic better and run faster. They sounds
> right but I am not sure if this trivial approach is the best practice.
> Please advise.
>
> Thanks
>
> Perseus

Like so much else in this field ... it depends. Certainly there is nothing wrong with the approach. And the one big advantage is that, if properly implemented, it allows the more complex data transformations to take place in the database where they will be more efficiently processed.

Daniel Morgan Received on Mon Feb 24 2003 - 13:56:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US