Oracle-L: Re:RE: Alternative to Crystal Reports

From: Jay Wade <fish_dba_at_hotmail.com>
Date: Thu, 20 Jun 2002 14:50:02 -0800
Message-ID: <F001.0048395D.20020620145002@fatcity.com>

Business Objects is good although the learning curve is pretty big. Although it is like anything and you have to watch the SQL statements that are used. We had a client bring there production system to its knees with a few poorly designed reports.

>From: dgoulet_at_vicr.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re:RE: Alternative to Crystal Reports
>Date: Thu, 20 Jun 2002 14:18:42 -0800
>
>Chris,
>
> Until some fool gives the general user this tool as a general purpose
>query
>tool. Then all hell breaks out.
>
>Dick Goulet
>
>____________________Reply Separator____________________
>Author: "Bowes; Chris" <Chris.Bowes_at_kosa.com>
>Date: 6/20/2002 1:33 PM
>
>I have yet to see something that I cannot do in Crystal Reports. However,
>I
>don't write the reports off of tables, I use stored procedures to query and
>process the records and return cursors to the crystal report. That way all
>the data is massaged and pre-formed and the report is but a "template".
>When done this way, you can send in parameters to determine what to do with
>the data before it gets to the report. I'll have the same query with
>differing where clauses and use something like if i_date is not null then
>use query one which has a date range find else use query2 which ignores
>date. Or you can create a query of groups and summaries and send it to
>Crystal and Crystal will look at each summarized record as if it was just
>another record from the base. Using stored procedures, you can do unions,
>summaries, calculated fields, dummy fields, literals, etc and crystal can
>handle it no problem. It is quite robust when done this way.
>
>--Chris
>
>
>
>
>____________________Reply Separator____________________
>Author: "Steve McClure" <smcclure_at_usscript.com>
>Date: 6/20/2002 10:17 AM
>
>Several times in the past I have seen folks on this list refer people to a
>reporting product to use as an alternative to Crystal reports. Apparently
>I
>didn't think I would need it, cause I usually save posts with information I
>am likely to forget.(So Yeah, I do save a lot of posts) Well now Crystal
>is
>being touted here as a possible solution for a new client's reporting
>requirements. We have been unable to convince Oracle Reports to perform in
>the way we would like, so we need an alternative. The good thing is that
>the new client is a large one, so my company will actually be able to
>invest
>in a nicer product.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve McClure
> INET: smcclure_at_usscript.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: dgoulet_at_vicr.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
><HTML>
><HEAD>
><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
><META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
><TITLE>RE: Alternative to Crystal Reports</TITLE>
></HEAD>
><BODY>
>
>I have yet to see something that I cannot do in Crystal
>Reports.  However, I don't write the reports off of tables, I use
>stored
>procedures to query and process the records and return cursors to the
>crystal
>report.  That way all the data is massaged and pre-formed and the
>report is
>but a "template".  When done this way, you can send in
>parameters
>to determine what to do with the data before it gets to the report. 
>I'll
>have the same query with differing where clauses and use something like if
>i_date is not null then use query one which has a date range find else use
>query2 which ignores date.  Or you can create a query of groups and
>summaries and send it to Crystal and Crystal will look at each summarized
>record
>as if it was just another record from the base.  Using stored
>procedures,
>you can do unions, summaries, calculated fields, dummy fields, literals,
>etc and
>crystal can handle it no problem.  It is quite robust when done this
>way.
>
>--Chris
>
> 
> 
> 
>
>____________________Reply
>Separator____________________
> Author: "Steve McClure"
><smcclure_at_usscript.com>
> Date:       6/20/2002 10:17
>AM
>
>
>Several times in the past I have seen folks on this list
>refer
>people to a
> reporting product to use as an alternative to Crystal
>reports.  Apparently I
> didn't think I would need it, cause I usually save posts
>with
>information I
> am likely to forget.(So Yeah, I do save a lot of
>posts) 
>Well now Crystal is
> being touted here as a possible solution for a new
>client's
>reporting
> requirements.  We have been unable to convince Oracle
>Reports to perform in
> the way we would like, so we need an alternative. 
>The
>good thing is that
> the new client is a large one, so my company will actually
>be
>able to invest
> in a nicer product.
>
>
>-- 
> Please see the official ORACLE-L FAQ: <A
>HREF="http://www.orafaq.com"
>TARGET="_blank">http://www.orafaq.com</A>
> -- 
> Author: Steve McClure
>   INET: smcclure_at_usscript.com
>
>
>Fat City Network Services    -- (858)
>538-5051  FAX: (858) 538-5051
> San Diego,
>California       
>-- Public Internet access / Mailing Lists
> <FONT
>SIZE=2>--------------------------------------------------------------------</FON
>T>
> To REMOVE yourself from this mailing list, send an E-Mail
>message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
>'ListGuru')
>and in
> the message BODY, include a line containing: UNSUB
>ORACLE-L
> (or the name of mailing list you want to be removed
>from).  You may
> also send the HELP command for other information (like
>subscribing).
> -- 
> Please see the official ORACLE-L FAQ: <A
>HREF="http://www.orafaq.com"
>TARGET="_blank">http://www.orafaq.com</A>
> -- 
> Author: 
>   INET: dgoulet_at_vicr.com
>
>
>Fat City Network Services    -- (858)
>538-5051  FAX: (858) 538-5051
> San Diego,
>California       
>-- Public Internet access / Mailing Lists
> <FONT
>SIZE=2>--------------------------------------------------------------------</FON
>T>
> To REMOVE yourself from this mailing list, send an E-Mail
>message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
>'ListGuru')
>and in
> the message BODY, include a line containing: UNSUB
>ORACLE-L
> (or the name of mailing list you want to be removed
>from).  You may
> also send the HELP command for other information (like
>subscribing).
>
>
></BODY>
></HTML>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: dgoulet_at_vicr.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jay Wade
  INET: fish_dba_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Jun 20 2002 - 17:50:02 CDT