Unanswered: Creating Reports with RDC and many databases
I have a question in that someone has given me a fairly complex report where they create a report which comes from both Oracle and Access. The data from these two databases are in one report and it would have been best if the report desiger used sub-reports. Nonetheless, his report bombs on Crystal Enterprise even though it works fine on Crystal Reports 11.
My question is this. I need to trick Crystal Reports to use two different providers at run time. I can programattically tell crystal to use Oracle in the main report and I can do so as follows:
Dim CRXApplication As New CRAXDRT.Application
Dim CRXReport As CRAXDRT.Report
Dim strApplicationSourceReports As String
Set CRXReport = CRXApplication.OpenReport("D:\TEST\TEST.rpt")
Dim ConnectionInfo As CRAXDRT.ConnectionProperties
Set ConnectionInfo = CRXReport.Database.Tables(1).ConnectionProperties
'cRXReport.Database.Tables(1).DllName = "crdb_odbc.dll"
ConnectionInfo.Add "DSN", "LOCAL"
ConnectionInfo.Add "User ID", "jcones"
ConnectionInfo.Add "Password", "yellow!"
ConnectionInfo.Add "Provider", "MSDAORA"
However, can I set other ConnectionInfo parameters before I print out the records?