Problem Using Views

[IanWaterman]

We are using CR10 on an Oracle 8 database.

I am working with a software developer and we are constatntly switching schema names when developing new reports for new clients. To ensure reports are portable across schemas we routinely remove schema name by going into Datasource and entering the fully qualified name, this effectively removes schema name from SQL statement.

We now have a new client where this has been fine too until now. They switched to a new database and since then we have not been able to add any views to existing reports.

We can see the view in the database expert, join view in links tab and then see view in Data explorer. As soon as we try to add a field report crashes. When we reopen, view is still there but no longer joined to existing tables. If we rejoin same thing happens.

We can build completely new reports using views and tables, we just cannot update existing reports. I have never seen this before so any ideas or suggestions gratefully received.

Ian Waterman

 

[Turkbear]

Hi,
Can you report on just the new view?

The report 'crashing' indicates some deeper problem than just the view. If CR cannot handle the new view it should just fail to return any records, not crash..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[IanWaterman]

No if we add the new view to a new report it is fine, its only a problem when we try to add it to an existing report.

Ian