Message-ID: <F001.0047A18F.20020611045322@fatcity.com>
Date: Tue, 11 Jun 2002 04:53:22 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Stefan Jahnke <Stefan.Jahnke@bov.de>
Subject: AW: Off Topic, slightly - Crystal Reports internal format
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

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@radisys.com [mailto:Jared.Still@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@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@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@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@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).