Print Page | Close Window

Oracle and schema issue

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5527
Printed Date: 03 May 2025 at 4:31pm


Topic: Oracle and schema issue
Posted By: artbonsai
Subject: Oracle and schema issue
Date 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!


Print Page | Close Window