| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Alternative to Crystal Reports
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bowes, Chris
INET: Chris.Bowes_at_kosa.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 - 16:33:45 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |