crystal 10 report, need to run in different server and database
Posted on 2006-07-19
I have vb code to a crystal report 10, it works fine, if I have the report run in the same SQL server and database. However, if I run the report in different sql server and database, it will show up the Server1.DB1.procedure doesn't exist.
I need a way that I can dynamically change the servername and databasename when run the report, so the report can be run in different combination as long as the table/view/procedure exists.