Change to SQL Server-Help!!

[CP60]

Ok. We were using an Access Mdb on a server and have clients access the data through a VB 6 application.
The dynamic sqls would be sent to the engine to get the data and store it in a local temp table/tables, and the CR Report was based on this/these table(s) using the DAO db engine.

Now were are moving this to Sql Server 2005. Still using the VB 6 application and using CR-XI.

When a using selects their criteria and passed to a stored proceedure, the data is returned and used in a form or grid.

How do we get the data with the same criteria to a CR report? Does the data need to be pulled in a second time by CR which sometimes complicated criteris parameters?

I am a little confused at finding an efficient method for this. If the data needs to be pulled in again, then so be it. But how do I pass all the criteria from the VB application to CR which applies the criteria dynamically to the SQL statement?

I just need some step by step direction and advice here.

 

[hilfy]

I don't think you can pass the data dynamically from VB 6. If you were using VB.NET you could put the data into an ADO.NET dataset and use that to supply the data for the report.

So, you'll have to set up the parameters in Crystal and re-select the data in the report.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.