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