Passing Multiple Value Parameter from VB6 to Crystal 8?

[kmcclung]

I have a report created in v.8 with 3 parameter fields, one of which "Allows Multiple Values". I need help with the syntax to pass the multiple values from a VB6 app to generate the report. BTW - I'm not using RDC.
Any ideas????

 

[balves]

You're using the OCX? I don't know that you can pass multiple values with the OCX.

 

[kmcclung]

I'm wondering about trying to pass the SQL to Crystal from VB, instead of using the parameter fields. Any thoughts?

 

[balves]

Yes, you can certainly do that.

Get the parameters via a VB form, build the SQL string, and set the .SQLQueryString property with the SQL statement before executing the report.

 

[chelseatech]

Thre are some articles on this in the last few issues of Crystal Clear - available from

http://www.chelseatech.co.nz/pubs.htm

The RDC defintely gives you some more options. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[kenhamady]

You might also consider passing a recordset to the report. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com