Crystal reports and Sage Line 100

[pmgatwork]

Hi all

If i run a crystal report (version 9 to 11) on a sage database table I get the error
The database table cannot be found. Proceed to remove this table from the report

If I click no then the report continues to run, but if I click yes then the table is reomved from the report.

Has anyone managed to solve this problem

Thanks
Peter

 

[synapsevampire]

Sounds very odd.

Make a copy of the report and sequester it away before further testing.

Open the report and select Database->Verify Database and see if that resolves, or otherwise post what happens.

If that fails, try using database->verify database and go reppoint the report to the table.

Not sure what Sage is, I looked it up and there were a few databases named Sage, but I couldn't find a database company called Sage, are you referencing a name of a database as opposed to the type of database?

We'd need to know the type to assist you.

-k

 

[pmgatwork]

Ido found the solution which is to change the use default dsn properties to True in the Set Datasource Location properties in crystal

Many thanks