Pass Parameter using VB6 to CRv9

[RRAnthon]

Forgive me if I'm flogging a dead horse, but everywhere I've searched I find the .Net solution and not VB6. Using VB6 and CR9, using a stored procedure. When I select the SP in my report, it automatically creates a parameter which means I get the parameter prompt at run time. How do I programmatically pass the parameter using VB6 to the report at runtime so the report will run w/out prompting the user? Thank you!

 

[vidru]

Something like this:

crxRpt.ParameterFields.GetItemByName("@ParamName").AddCurrentValue strValue

-dave

 

[synapsevampire]

Here are the VB sample apps:

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

Dave: Have you switched sites or is it that you don't do much posting on technical forums these days?

-k

 

[vidru]

K - been way too busy with the 9 to 5, plus trying to get a handmade soap biz off the ground. I popped in today to poke around one of the SQL forums, and thought I'd drop in around these parts as well.

-dave

 

[RRAnthon]

Thanks for the help guys, that line of code does work, however, I found that I can still pass the parameter via the stored procedure when I use the following code after setting mrsDataSet as an ADOR.Recordset.

crReport.Database.SetDataSource mrsDataSet

I stumbled upon this fix Sunday afternoon. Thanks again for the help and the link!!