Record selection based on delimited list of values

[rjoubert]

I am passing a comma delimited string of integers into my report and I want to use that list of integers in my record selection formula. Here's what I have for that formula...

({Projects.ProjectID} in Split({?ProjectIDList}, ","))

CR XI is giving me an error when I check the formula, which states, "A number range is required here.", and it highlights the Split function. Any suggestions? Thanks...

 

[lbass]

Please explain how you have the parameter set up. Are you allowing multiple values? Range values? If so, why?

-LB

 

[rjoubert]

I had tried setting the multiple values property to True before, but after reading your question, I thought I'd give it another try. While I was trying to test that out, I figured out my problem. My ProjectID field is a numeric field and I had my parameter setup as a string. I changed the parameter to a number and set the multiple values property to True, and now I'm in business. Thanks for the help...