In this example the location property of the DatabaseTable Object for each table in Report is set to MDB File.
******************
For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.Location = App.Path & "\xtreme. mdb"
Next crxDatabaseTable
******************
I want to set the location to different Database residing on Sql Server. What Value should I assign to Location Property for it?

The Report is designed with DB1, DB2 contains same tables & relationships. I want to open the report using DB2's Tables. Is it the right way I am going abt?

I am new to RDC pls help..