Re: Off Topic, slightly - Crystal Reports internal format

Jared

1. for the dbname...why not just change the SID in TNSNAMES that the ODBC DSN is using to point to the snap-shotted(?) instance
2. I think private synonyms would be the way to go for the table naming problem. Why did they not just use the same names on the snapshot site....been there done that, got the T-shirt

HTH...or maybe I didn't understand your requirement =8-)

Jeff Herrick
Jeff Herrick & Associates

On Mon, 10 Jun 2002 Jared.Still_at_radisys.com wrote:

> 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: Jeff Herrick
  INET: jherrick_at_host.ott.igs.net

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