Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Oracle and schema issue Post Reply Post New Topic
Author Message
artbonsai
Newbie
Newbie


Joined: 16 Feb 2009
Location: France
Online Status: Offline
Posts: 1
Quote artbonsai Replybullet Topic: Oracle and schema issue
    Posted: 16 Feb 2009 at 11:20am
Hi!

I use Crystal report XI with an Oracle (10.1) database, and i've a little problem with schemas:

I've two schemas : A and B, and each have a table TABLE_DATA with the same name but differents structures:
A.TABLE_DATA : table with  7 columns
B.TABLE_DATA : table with 30 columns

With an SQL tool : SQL+, or Toad, i see correct structures for those tables.
But crystal report give me the two schemas/tables with the same structure!

A.TABLE_DATA : table with both columns (37 columns)
B.TABLE_DATA : table with both columns (37 columns)

When i want to create or modify a report, Crystal report give me an error :
"Impossible d'extraire des données de la base de données" [Impossible to extract data from database]

Would you have any suggestion to solve this problem?

Thanks!


Edited by artbonsai - 16 Feb 2009 at 11:28am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.033 seconds.