RDO Data Source Problems

[schudog]

Hey folks...

Here's the situation:
VB6
Crystal Reports 8 (Automation Server)
SQL Server

The report uses a stored procedure in SQL server as its data source. This sp exists in multiple databases which are also on multiple servers. So the deal is - at times I'll need to hit the same stored proc, but in different DB's on different servers.

To make a long story short - I can get a VB RDO resultset back from the stored proc I want to hit for the data, no sweat. But I'm having trouble getting the report to see it and I think its because the report isn't configured for an active data source. Right now it's just set to the stored proc in one database on one particular server.

So how do I go about getting this report to wake up and smell the active data? That's my problem. As an additional note - DSN's are not an option here - this vb app is running as part of an unattended batch process and is completely non-visual. All the app does is open the report and export it as a csv file. The server and database target values for the stored proc location come out of the host machine registry. And all that stuff works fine - just need to get the report and my RDO resultset playing nice.

Mucho Thank-ola.

SchuDog [sig][/sig]

 

[kenhamady]

SchuDog,

When you created the report, you selected a datasource which determined the driver used by the report. You have to convert the report's data driver to be Active Data.

Since the report is using one "Table" (the SP looks like one table to Crystal) you should be able to do this pretty easily. Open the report in the design environment and use the menu commands:

Database - Convert Database Driver

Check off the box and in the drop down select the Pdsmon.dll [ADO, RDO, DAO]. From there you can point it to one of your SP's just like you would in the Application. However, because you are reading this SP through the Active Data Driver, the report is now eligible to be passed a recordset.

If your report had two or more tables joined together within Crystal Reports, this technique would not work. You would have to recreate the report using a DDF text file. That is a real pain. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]