Pasting a list of values into a parameter field

building reports crystal reports
1

I want to be able to paste a list of values in a parameter window that opens when I run a report. I enter multiple values the way I would enter them in the record selection formula, but it does not work.

I have attached screen shots showing

  • my record selection formula:
  • how I set up the parameter:
  • how I am entering multiple values when I run the report:

Why doesn’t it return any records? If I enter [‘75001’,‘75002’] directly in the record selection formula, it returns those two records.

Thanks!
List of jobs_record selection formula.jpg
List of jobs_parameter.jpg
List of jobs_data entry window.jpg

Matteo_Luccio (BOB member since 2013-07-30)

2

I think entering the parameter like that makes it seem like a single value.
If it appears in the Window as 2 values it should put them in a list properly.
But then you can’t paste that way.

richardcottave (BOB member since 2006-03-30)