Skip to Content
0
Former Member
Jan 15, 2013 at 06:24 PM

Using Like Statement with Parameters

16 Views

I have an Excel document which has 7000+ login IDs which I need to use as parameters.

I have added them as a static parameter, and can use them in my report when I am looking at the Login ID table. I have to manually select each page and pull all Available Values into the Selected Values filed. This works, but I would like to find a more efficient way to do this.

On top of that, I need to parse a "Description" field (free form) for those same login IDs. I have been trying to find some way to use the Like function with the Parameter.

I have tried using Like "*" + {?LogIDs} + "*" in the Select Expert. But when I run the report, Crystal blows up and shuts down.

I have tried putting it in a Formula, but I get an Array error message.

Any help would be greatly appreciated.