Nick,
thanks for your info. Actually, we may be set against
using crystal because of lack of some features. I was
thinking that may be these features are there, but we
have missed them. Looks like they are indeed not
there.
Also the feedback I had from others seems to be fairly
negative. So we may end up using some other tool after
all
- Nick Wagner <Nick.Wagner_at_quest.com> wrote:
> if you are dead-set using crystal... I feel your
> pain. In a previous life
> (job) I was a report writer/integrator... we used a
> Delphi front end, and
> Crystal provided us a couple of nice utilities to
> get into the structure of
> the application and change many of the queries and
> results. We would give
> it different queries to run, different where
> clauses, even include hints.
> And then we gave our users a limited number of
> different options in the gui
> so they did not hurt themselves or our database.
>
> otherwise, skip to something a little nicer... I
> have heard Brio works very
> well.
>
> Nick
>
> -----Original Message-----
> Sent: Thursday, January 03, 2002 9:56 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi all:
>
> My users are considering using Crystal reports as an
> ad-hoc tool to query a DSS. They ran into several
> issues however using it. I was wondering if someone
> out there has ehough experience with that tool to
> shed
> some light.
>
> Issue 1. Whenever Crystal creates a query it only
> create a one-pass sql. If the sql goes against a
> large
> number of large tables, we'd rather have the query
> split into several smaller 'create table as"
> statements, the result sets of which will be
> combined
> into the final result set. IS there a option in
> Crystal to allow the "multi-pass" queries?
>
> Issue 2. Kind of subset of the previous one. Does
> Crystal allow users to create tables at all? It
> seems
> to be a "read only" tool as far as we can see. Is
> this
> correct?
>
> thanks for any help
>
> Gene
>
> =====
>
>
> __________________________________________________
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gene Gurevich
> INET: g_u_r_e_v_i_c_h_at_yahoo.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).
>
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Gurevich
INET: g_u_r_e_v_i_c_h_at_yahoo.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).
Received on Fri Jan 04 2002 - 12:03:31 CST