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

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 20 Jun 2002 23:43:22 -0800
Message-ID: <F001.00483D90.20020620234322@fatcity.com>

Also thing big $$$$$$$$$$.
Business Objects is much more expansive.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, June 21, 2002 12:50 AM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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 Fri Jun 21 2002 - 02:43:22 CDT