CRYSTAL REPORT 9 Changing Connection Properties
I'm using crystal report and vb6. how can i change the connection properties of the crystal report in vb6?
In my crystal report i used stored procedure to create the report. What if i change my database name how can i change the properties in vb6 so i wouldn't change the crystal report anymore. im using ms sql server.
this is my code...
Global crxReport As CRAXDRT.Report
With crxReport.Database.Tables
For intCount = 1 To .Count
.Item(intCount).ConnectionProperties.Item("Data Source") = sServer
.Item(intCount).ConnectionProperties.Item("Initial Catalog") = sDBName_
.Item(intCount).ConnectionProperties.Item("User Id") = sUserName
.Item(intCount).ConnectionProperties.Item("passwor d") = sPassword
Next
End With
the reports are working fine but if i change my database name it doesn't work anymore...
|