Oracle Discoverer? -- Alexandre
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 2:54 PM > How about something like Brio Query? Some friends of mine in Holland sell > this (Jack?) and it's supposed to be a pretty good solution.. > > www.brio.com > > HTH > > Mark > > =================================================== > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > =================================================== > http://www.cool-tools.co.uk > Maximising throughput & performance > > > -----Original Message----- > Sent: 21 June 2002 08:43 > To: Multiple recipients of list ORACLE-L > > > Also thing big $$$$$$$$$$. > Business Objects is much more expansive. > > Yechiel Adar > Mehish > ----- Original Message ----- > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >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" <[EMAIL PROTECTED]> > > >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" <[EMAIL PROTECTED]> > > >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: [EMAIL PROTECTED] > > > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > >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: [EMAIL PROTECTED] (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> > > > > > ><P><FONT SIZE=2>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.</FONT></P> > > > > > ><P><FONT SIZE=2>--Chris</FONT> > > ></P> > > ><BR> > > ><BR> > > ><BR> > > > > > ><P><FONT SIZE=2>____________________Reply > > >Separator____________________</FONT> > > ><BR><FONT SIZE=2>Author: "Steve McClure" > > ><[EMAIL PROTECTED]></FONT> > > ><BR><FONT SIZE=2>Date: 6/20/2002 > 10:17 > > >AM</FONT> > > ></P> > > > > > ><P><FONT SIZE=2>Several times in the past I have seen folks on this list > > >refer > > >people to a</FONT> > > ><BR><FONT SIZE=2>reporting product to use as an alternative to Crystal > > >reports. Apparently I</FONT> > > ><BR><FONT SIZE=2>didn't think I would need it, cause I usually save posts > > >with > > >information I</FONT> > > ><BR><FONT SIZE=2>am likely to forget.(So Yeah, I do save a lot of > > >posts) > > >Well now Crystal is</FONT> > > ><BR><FONT SIZE=2>being touted here as a possible solution for a new > > >client's > > >reporting</FONT> > > ><BR><FONT SIZE=2>requirements. We have been unable to convince > Oracle > > >Reports to perform in</FONT> > > ><BR><FONT SIZE=2>the way we would like, so we need an alternative. > > >The > > >good thing is that</FONT> > > ><BR><FONT SIZE=2>the new client is a large one, so my company will > actually > > >be > > >able to invest</FONT> > > ><BR><FONT SIZE=2>in a nicer product.</FONT> > > ></P> > > > > > ><P><FONT SIZE=2>-- </FONT> > > ><BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A > > >HREF="http://www.orafaq.com" > > >TARGET="_blank">http://www.orafaq.com</A></FONT> > > ><BR><FONT SIZE=2>-- </FONT> > > ><BR><FONT SIZE=2>Author: Steve McClure</FONT> > > ><BR><FONT SIZE=2> INET: [EMAIL PROTECTED]</FONT> > > ></P> > > > > > ><P><FONT SIZE=2>Fat City Network Services -- (858) > > >538-5051 FAX: (858) 538-5051</FONT> > > ><BR><FONT SIZE=2>San Diego, > > >California > > >-- Public Internet access / Mailing Lists</FONT> > > ><BR><FONT > > > >SIZE=2>-------------------------------------------------------------------- > </FON > > >T> > > ><BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an > E-Mail > > >message</FONT> > > ><BR><FONT SIZE=2>to: [EMAIL PROTECTED] (note EXACT spelling of > > >'ListGuru') > > >and in</FONT> > > ><BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB > > >ORACLE-L</FONT> > > ><BR><FONT SIZE=2>(or the name of mailing list you want to be removed > > >from). You may</FONT> > > ><BR><FONT SIZE=2>also send the HELP command for other information (like > > >subscribing).</FONT> > > ><BR><FONT SIZE=2>-- </FONT> > > ><BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: <A > > >HREF="http://www.orafaq.com" > > >TARGET="_blank">http://www.orafaq.com</A></FONT> > > ><BR><FONT SIZE=2>-- </FONT> > > ><BR><FONT SIZE=2>Author: </FONT> > > ><BR><FONT SIZE=2> INET: [EMAIL PROTECTED]</FONT> > > ></P> > > > > > ><P><FONT SIZE=2>Fat City Network Services -- (858) > > >538-5051 FAX: (858) 538-5051</FONT> > > ><BR><FONT SIZE=2>San Diego, > > >California > > >-- Public Internet access / Mailing Lists</FONT> > > ><BR><FONT > > > >SIZE=2>-------------------------------------------------------------------- > </FON > > >T> > > ><BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an > E-Mail > > >message</FONT> > > ><BR><FONT SIZE=2>to: [EMAIL PROTECTED] (note EXACT spelling of > > >'ListGuru') > > >and in</FONT> > > ><BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB > > >ORACLE-L</FONT> > > ><BR><FONT SIZE=2>(or the name of mailing list you want to be removed > > >from). You may</FONT> > > ><BR><FONT SIZE=2>also send the HELP command for other information (like > > >subscribing).</FONT> > > ></P> > > > > > ></BODY> > > ></HTML> > > >-- > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > >-- > > >Author: > > > INET: [EMAIL PROTECTED] > > > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Mark Leith > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).