Using Command in Reports...Table could not be found

[aky1234]

Hi all,

Im using command through database expert for selecting tables.they are working fine on my local machine ,But when i publish the reports on to the crystal enterprise Im getting an error as 'table not found'. the reports that doesn't use command are fine. Im using using CR10 on Windows 2000 and CE 10 is on Solaris. Is there something that need to be configured??

Thanks in Advance

 

[synapsevampire]

What type of database/connectivity are you using? Since your question is about a database connection, you should post technical information for it.

The CE server will require the same connectivity and rights, so make sure that it also has the same connectivity (such as ODBC) and that the user/pw on CE has permission to the same objects.

-k

 

[aky1234]

hey synaps
I do not have any problem with database connectivity.. as the other reports with out using command are working fine ,yes CE server has the same connectivity and rights

 

[synapsevampire]

Well, if you decide that it isn't too much trouble to post the database/connectivity I'll try to help.

-k

 

[aky1234]

the connectivity is something like this..if it helps

Database Type- ODBC, Data Source Name xyz ,User ID -XXXX ,Password -YYYY ,Use DSN Default Properties - False

ON the Enterprise

Im using custom database logon

database driver - Oracle

Server: abcd
Database: xyz
user: xxxx
Password : yyyy
specify a custom table prefix- hrrp.

Note: If I select a table from database with out using the Command the reports are running fine