Crystal 9 uses 'Set Location' differently to earlier versions 2

[Gordon68]

When I wrote reports in version 7 I used Database | Set Location to remove the datasource to leave just the table name, i.e. DATABASE.people was changed to people. This was required to get the report to run on any Oracle database, whatever the name. (The tables will always be the same.) The final result required is the 'Show SQL' to have no reference to databases.

 

[vidru]

Here's the whitepaper:

http://support.businessobjects.com/library/kbase/articles/c2014760.asp

Make sure you've got the latest service packs and hot fixes install as well.

-dave

 

[Gordon68]

Thank you vidru

You turned a difficult / impossible situation around.