My personal favorite.
If you want pretty charts, learn Perl and use DBD::Chart. Amazingly easy to do. Jared On Friday 21 June 2002 06:48, Loughmiller, Greg wrote: > Alternative to Crystal: The "Cheap Man's Reporting when you have no > capital/software budget" > > sql*plus formatting via Unix scripts to html format :-) > > > greg > > -----Original Message----- > Sent: Friday, June 21, 2002 3:43 AM > 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: Jared Still 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).
