Re: AW: Off Topic, slightly - Crystal Reports internal format

Brian,

Thank you, that appears to be the solution!

Just hadn't explored enough yet.

Jared

On Tuesday 11 June 2002 15:31, Anderson, Brian wrote:
> In 8.5 developer on the "database" menu, is an option of "set location".
>
> This lets you pick a new connection/table for any table in the report,
> and then it asks if you would like to change all similiar references.
> So you can change one and let it try to match the others, or change each
> table reference yourself.
>
> I don't have 8 installed to see if their is something similiar, but
> maybe that will give you a direction to look.
>
> Do you have "standard", "professional" or "developer"? That may
> determine whether you have this option.
>
>
> ***********************************
> Brian L. Anderson
> SA/DBA
> Darton College
> andersob_at_darton.edu
> -----------------------------------
> http://home.earthlink.net/~maryranderson
>
> > -----Original Message-----
> > From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> > Sent: Tuesday, June 11, 2002 2:29 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: AW: Off Topic, slightly - Crystal Reports internal format
> >
> >
> > Arrgggghhh!!!!!
> >
> > Now that the primal scream is out of the way, there must be some
> > kind of workaround. Still looking...
> >
> > Jared
> >
> >
> >
> >
> >
> > Stefan Jahnke <Stefan.Jahnke_at_bov.de>
> > Sent by: root_at_fatcity.com
> > 06/11/2002 05:53 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: AW: Off Topic, slightly - Crystal
> > Reports internal format
> >
> >
> > Hi Jared
> >
> > Regarding your first problem:
> > I experienced the same "feature" a while ago.
> > Seagate promised that one is able to just change
> > an underlying ODBC connection and that the report
> > should be able to run different data sources.
> > Bunch of bull. Looks like it still doesn't work
> > correctly.
> >
> > And yes, we had to reengineer EVERY single report.
> > CR support ? VERY ah, ... not helpful.
> >
> > Regards,
> > Stefan
> >
> > -----Ursprüngliche Nachricht-----
> > Von: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> > Gesendet: Montag, 10. Juni 2002 23:43
> > An: Multiple recipients of list ORACLE-L
> > Betreff: Off Topic, slightly - Crystal Reports internal format
> >
> >
> > List,
> >
> > I have an 'opportunity' to make some points with end users,
> > if possible.
> >
> > I'm booting the crystal reports users off of my production
> > databases (
> > including
> > SAP, can you believe that? ).
> >
> > There reports will now run against a reporting server with
> > snapshotted
> > tables.
> >
> > Their reports have been written with Crystal Reports 8 via ODBC.
> >
> > 2 problems:
> >
> > 1) When originally setup, the ODBC DSN matched the name of
> > the database.
> > Not smart I know, but I inherited it. Changing the data
> > source in Crystal
> >
> > basically
> > forces you to rewrite the report.
> >
> > 2) The username has changed. Production is CIMUSER,
> > reporting is CIM_MV.
> > The table names have '_MV' suffix in the reporting database.
> >
> > Any reasonable tool would allow you to change these items
> > without too much
> >
> > fuss.
> >
> > Either CR8 is not reasonable, or I have just not found out
> > how to do it
> > yet. Without
> > reconstructing the report that is.
> >
> > Any tips, resources, what have you are welcome.
> >
> > If you know of any documentation detailing the *.rpt file
> > format, that
> > would be most
> > appreciated, as I could just modify their reports from the
> > command line or
> >
> > with a
> > hex editor.
> >
> > Thanks,
> >
> > Jared
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.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).
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Stefan Jahnke
> > INET: Stefan.Jahnke_at_bov.de
> >
> > 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).
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).