Passing Parameter from VB6 to CR9

[longfellow]

Versions VB 6 CR 9 and SQL Server 2000

I run a form in VB which will (execute a SQL procedure) and should then pass a date parameter to the crystal report which has to give the report for the day of the qname, caller id and the total calls. Can anyone very briefly tell me what I should do in both VB (passing of parameters to CR ) as well as in CR (defining or linking the parameters) for the whole process to be completed.There is no other code on the form. I just have to pass the parameter from the form to Cr and generate the report. If I could do this with a single form then I will integrate this across several forms in the project.

 

[synapsevampire]

You might simplify all of this aand just call a stored procedure from within Crystal which returns the data required itself.

Check:

http://support.businessobjects.com/communityCS/TechnicalPapers/apps_rdc.pdf

Search for:

Parameter Fields

There are a few example apps.

-k