Tables & Views

[deeya]

Crystal 11
Oracle v9

Hello All!

Im in the middle of upgrading our reports from v7 to v11 and have the following issue veryfiying the DB.

We have 2 schemas one for 'test' and one called 'main'. In v7 the views and tables come prefixed with EMSMAIN or EMSTEST e.g EMSMAIN.LK_NON_ACTIVE but in v11 I cant see the prefix.

The id I use to run the reports can see both test and main so in v11 i see two views or two tables without the prefix.

Ive tried the set location option but it throws an error 'Data Object cannot be opened/accessed'

Can anyone help?

Best Regards

JP

 

[deeya]

Sorry just to add if I run the report it tells me that view "LK_NON_ACTIVE cannot be found. Proceed to remove this table from the report?".

Even though i select no the report still runs and pulls data from the view LK_NON_ACTIVE. I can also browse the fields OK.

Thanks

 

[deeya]

Update:

When verifying the database any view cannot be found although data still gets pulled into the report.

After some investigation I found in 'Set Datasource Location' in the properties for the view the Table Type is set to Tables instead of view!

1. Is this a known issue?
2. Is there a solution for it apart from re-adding the view and mapping?

Help Please!!!