report.Database.SetDataSource ?????

[Guest_imported]

how work this???

can use this for change the path of my database dinamyc

please somebody helpp memmmmm

 

[melginger]

depending of your method...

In my case from VB a just do

report.Database.SetDataSource (myrecordset)

where Myrecordset is the new recordset you want to assign

 

[balves]

Use .SetDataSource if you originally built your Crystal Report using an ADO recordset and want to pass the recordset at run-time.

Use .SetLoginInfo or .LogonServer to connect to the db. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer

 

[Guest_imported]

can you give me some code example for connect my report to a database from any different physical location?

will be apreciate, because i am frustated getting this information, i can´t find it.

thank´s in advance..

 

[balves]

Dim Report as CrystalReport1

...

Report.Database.Tables(1).SetLogOnInfo "server name", _
"db name", "username", "password"

or

Report.Database.Tables(1).SetLogOnInfo "DSN", , "username, "password" Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer

 

[Guest_imported]

1. if the report link different table, i need to put .tables(2),.tables(3) for each table???...

2. i can use the especific location, like this
Report.Database.Tables(1).SetLogOnInfo "\\computer1\database.mdb", , "username, "password"

 

[balves]

If all the tables come from the same db, you only need one call to .Tables(1).

I don't think you use .SetLogonInfo for MS Access. Is it a password protected database? If not, there's nothing to login to. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer