Set the Database connection in report at runtime in VB 6.0
I have a report created in CR XI that connects to the oracle server. The report works fine if I have same Service name in the tnsnames.ora file which I had used while creating the report.
But I dont want that. I want that I pass a recordset directly to the report and it uses the connection that was used to create the recordset. but it doesnt do that and I get "Failed to open the connection" error
This is the way I have the code
dim lrpt as CRAXDRT.Report
Can someone tell how can I make this working??