How to pass an array to the Crystal report record selection formula

[leaf3]

If several names from the name list box are selected how can I pass that many names to a record selection formula in Crystal Report? Thank You.

 

[LMCRYER]

I need more information - are you using a stored procedure on your back end and reading the parameter as an array into Crystal? What datasource? What version of Crystal?

 

[leaf3]

It is Crystal 6. I am not using a stored procedure. I just tried to pass an array to "CrystalReport1.SelectionFormula". Access is the datasource.

 

[kenhamady]

CR6 doesn't allow multiple parameters, but you could pass the 3 names as a single long string and then use:

{field} in "string"

As your selection formula.

Or you could build the following formula in VB as a string and pass it in as the selection formula:

{field} in ["name1","name2","name3"] 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

 

[jhein]

Ken,

I am using Crystal 9.0 and I am wondering the same thing. I am not using a stored procedure in this case and I am wondering if I can pass an array to the selection expert. I would like to have the user select one or more values from a drop down, and from there take that value to the select expert and build up my criteria. Basically instead of using the IN clause that gets greated by the multi select of a drop down I want to be able to take the array and create AND statements with the values. Is this possible?

Thanks