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 [EMAIL PROTECTED] ----------------------------------- http://home.earthlink.net/~maryranderson > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > 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 <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 06/11/2002 05:53 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > 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: [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: Stefan Jahnke > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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).
