on 04-21-2008 4:23 PM
Post Author: hokiegirl
CA Forum: Crystal Reports
I am trying to create a Crystal Report and pull data from an Oracle database and a Sybase database. One of the key fields I need to link on is defined dfferently on both. The Oracle DB field is defined as 'String(60)' and on the Sybase the field I want to link with is defined as 'number'. When I try and grab and link between the two in the Database Expert link section, I get an error: data types are not compatible". Does anyone have a way around this I can use? This is a link that I must have.
Thanks
Post Author: amr_foci
CA Forum: Crystal Reports
there is something called heterogeneous services in oracle which allow you to make a DB link form oracle to any other databases, like Sybase, SQL Server, ,,,,etc,
or you can go to business views in Business objects,
good luck
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Post Author: Bas Wijne
CA Forum: Crystal Reports
Why dont you create a table in one of the databases that matches the type of the other one?(ie. create a 'String(60)' table in Sybase populated with the date from the Sybase 'number data')Should do the trick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.