Database expert specifies database name in "FROM" clause

[Former Member]

Hello,

I am searching for a way to change change a report's database at run time (via C#/"ReportDocument.SetDatabaseLogin") but the database expert embeds the database name in the query so it fails when the database is changed:

SELECT

carton_type.description, ...

FROM

dev2.dbxx.carton_type carton_type

The databases are Sybase ASE and it seems "Add Command" is unavailable. Is this so? What are my options?

Database DLL: crdb_p2ssyb10.dll

Using Crystal Reports V12

Thanks,

JErwin

[former_member183750 · Accepted solution]

Please search the forum first. There are so many great examples of how to log on to a database... Try the suggested solutions, if you then have an issue, please post the details of the issue.

Ludek

Edited by: Ludek Uher on Oct 16, 2008 7:18 AM

[former_member11696]

Hi John,

If the Add Command is not available using the native driver it means we don't support it. Convert your reports to use ODBC and then you should have the option.

As Ludek suggested, search forums for more info on how to set the log on properties.

Thank you

Don