Passing Comma Separated Values in Parameter

[hgraybill]

I've searched for the answer to this, but to no avail.

I have a parameter on a report that is setup to accept multiple discrete values. For multiple values, the user has to enter each one and then hit the add button. Is there a way for them to copy a comma separated list into the parameter box and then hit add? The list would be like Value1, Value2, Value3, etc.

I know how to do this in VB, but I'm not sure if Crystal will allow this with some programming.

Thank you!

 

[Turkbear]

Hi,
Have the parameter set to a single value type --

In your record selection formula use that comma-separated string in an IN statement, like:

{sometable.somefield} IN ({?Paramener})..

Most databases will not care if the values are not quoted ( 'value') but if needed, have it in the pasted list.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hgraybill]

That works perfectly. I didn't need the quotes in Crystal.

Thank you very much!