Skip to Content
0
Former Member
Feb 19, 2009 at 02:33 PM

CR Xi Field Explorer error with Oracle 10.1 different schemas

33 Views

Hi!

I use Crystal report XI with an Oracle (10.1) database, and i've a little problem with schemas in Field Explorer of IDE.

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 x fields

B.TABLE_DATA : table with y fields

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

My report uses only the fields of A.table, but in fields explorer, i see all fields of my two tables in the same structure (TABLE_DATA with A.TABLE_DATA fields and B.TABLE_DATA fields).

With a refresh of fields, the problem is not corrected. I want to see only A.TABLE_DATA fields in explorer fields without redefining my database connection.

Would you have any suggestion to solve this problem?

Thanks!