Change the database at run time for Crystal Reports

[shailesh32]

How do we change the database at runtime for crystal reports. I declared rpt1 as Craxdrt.Report
And at runtime i would like assign a different database to the rpt1.

Thanks in advance

 

[mobashir]

To change location of db file for specific table
rpt1.Database.Tables(1).Location = "c:\abc.mdb"
Or
Assign recordset to table, recordset can be popultated from
any datasource
e-g assume Rs as ADODB.Recordset
rpt1.Database.Tables(1).SetDataSource Rs

 

[tb]

or . .

CrxRpt.Database.Tables(1).SetLogOnInfo "Server", "Database", "UserName", "Password"
CrxRpt.Database.Tables(1).Location = "Database.dbo.TableName"

'Using the CRViewer Control
crvRPTView.ReportSource = CrxRpt


"All I ask is the chance to prove that money can't make me happy." - Spike Milligan

 

[Glasgow]

It is worth noting that there is a separate Crystal Reports forum too!