Connection Info

[TonySaliba]

I am working on a project where I need to pass connection info to a report at runtime, I am using VS.Net with integrated Crystal Reports. It seems that the only parameters possible are :-

DataBaseName
ServerName
Password
UserID

From test it seems that the only way I could pass parameters is that these are through ODBC and must have the same DSN as the original report design. where

Databasename = DSN
ServerName= DSN
Password = PW
UserID =PW

Currently I have the following routine.

connInfo is a shared class holding Databasename, Servername, password and UserId which I am entering at runtime.

crTables is a collection of the tables in the report.

For Each crTable In crTables
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo = ConnInfo
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next


Altough there is documention "cr_rdc9_connectionproperties.pdf" on crystal decisions site it seems that this is not valid for crystal reports integrated with VS.net.

At minimum I need to conenct to MS-SQL, Access and Oracle by providing runtime values.

I appreciate some help on what options there are for the connectioninfo properties to be set at runtime.