Trying to input list with multiple values in Crystal

[mdieckman]

I am trying to copy/paste a list of values from excel into Crystal and have it return the list of values, but I am kinda new to crystal and I need help with the formula.

How do I make a formula so I can input a list of values and have it compare it to the field?

{field.fieldname} in {}

 

[lbass]

A record selection formula (report->selection formula->record) should look like:

{table.fieldname} in [value1,value2,value3] //etc.

If they are strings, the values should be enclosed in quotes:

{table.fieldname} in ['value1','value2','value3']

Not sure if this is your question.

-LB

 

[mdieckman]

I guess I was wondering if there was a way to have a text box popup to enter a list of values or having the option to enter a list of values when I ran the report. The values in the textbox would then be compared to the field and return any matching values.

Sorry for not rephrasing it better earlier. Would the code you posted work with what I am trying to accomplish?

I appreciate you help.

 

[mdieckman]

Anybody?

 

[mdieckman]

Nevermind, I figured it out.

 

[lbass]

Please explain what you did, so others can benefit. It sounded like you wanted to set up a parameter list of values, based on the Excel spreadsheet. You could have saved that as tab-separated text file and then imported that into the parameter list of values. What did you do?

-LB

 

[mdieckman]

I did exactly what you said. I was able to setup a parameter so that a list of values can be entered. Although, I didn't try the last part with the tab separated values. I'll give that a shot on Friday when I go back to work. Thanks.