Crystal Reports: Formula for multiples value lookup
Posted on 2013-12-03
Thank you in advance, as this issue has been puzzling me for a while.
Here is what I am trying to do. I have a field name "COMBINED_RESOURCES", which can contain multiples resources that are speperated by a comma and a space so ", ". Here is an example output:
NOC Operations, Critical Engineering, Video Operations, Maryland Headend
or it can be just a single resource without a comma like:
I want to be able add multiple resources to a parameter and return the values if any of those values in the parameter is in the "COMBINED_RESOURCES".
so, lets say I add in the parameter:
It should return the following records:
1 NOC Operations
2 NOC Operations, Video Operations
3 Critical Engineering, Video Operations
Thank you, so much!