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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Business Objects Vs Oracle Reports for batch reports

Re: Business Objects Vs Oracle Reports for batch reports

From: david wendelken <davewendelken_at_earthlink.net>
Date: Mon, 7 Nov 2005 13:05:05 -0500 (GMT-05:00)
Message-ID: <11384663.1131386705804.JavaMail.root@elwamui-rustique.atl.sa.earthlink.net>

>My main issue is performance; how BO fares with Oracle Reports. I heard BO
>does the joins on the client side;

That is not completely true.

Be aware that many Crystal Reports (CR) programmers are woefully deficient in their SQL skills. They use the query generators built into the product with no understanding of how the query works. Their mindset is "do it in CR", so they will do all processing in CR because that is what they know. Much of the advice you will get from the CR forums (www.Tek-Tips.com has several excellent ones) is biased by this ignorance of how to approach the problem from the sql side of things.

It is possible to build a query by hand and put it into CR. The query can be pretty sophisticated. UI support for this capability is rather sad - it's harder to do than it needs to be and not very sophisticated about changes to the underlying query. If you go this route, do as much formatting as possible in the query to minimize rework in the layout editor.

CR is far superior to Oracle Reports (OR) when it comes to building a simple report easily. It's much easier to do easy things in CR.

OR has much more capability. It's much easier to do hard things in OR. Poor to average-skilled programmers don't tend to like it, because it takes a data-centric view of building a report, and CR takes a printed page view of the task. I consider OR to be a much more versatile product. In addition, the way CR handles allowable parameter values is simply laughable - except to the poor sods who have to maintain the addition of 1 new code value to 200 reports that all use that parameter.

But - unless you really need the extra power that OR gives you, the training investment in CR probably outweighs the extra capability. Training most programmers is expensive.

Hope that helps.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 07 2005 - 12:11:55 CST

Original text of this message

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