Sage 100

I'm using the Category3 field in Item Maintenance to capture a sequence of letters (LFS) that define item assortments. Have a custom report with a parameter field and need to define selection criteria that returns records which contain any of the predefined values. Unfortunately, the only available operator (as regards to the parameter field) is ""Equal To."" How can I define the selection criteria so as to include records that contain any or all of the letters within my parameter field? I tried ""{CI_Item.Category3} in {?Assortment}"", but the ""in"" will not stick (reverts back to equal to).

You need to have the parameter set to allow mulitiple values. The selection will still be Equal to but they can choose multiple values and it works.

@ThereseLogeais I do have it set to allow multiple values. I think what's happening is that if I select all of them (LFS), then Crystal is looking for records where Caterory3 = ""LFS"". What I need is Category3 contains ""L"" or ""F"" or ""S"".

I just PM'd you. Call me to discuss.

Can you work it from the other end and make a formula in Crystal that checks if the value input is contained within the Cat3 ? If so then set a variable equal to the Cat3 value? Then Variable = Cat3 passes. I'm sure this is hoky but seems as if it could work. If {CI_Item.Category3} in {?Assortment} = xxx then Variable = {CI_Item.Category3} Or somesuch Or you can just create a flag Y/N as to whether to select an item. I've done that before as well.

Here's what I ended up doing: created 3 parameter fields and set selection criteria as follows: ({?Frontgate} in {CI_Item.Category3} or {?Label} in {CI_Item.Category3} or {?Stock} in {CI_Item.Category3}). This displays data regardless of how many of the 3 letters are in Category3 or in what order they appear. Ideally, I'd have preferred to use a single parameter field with multiple values, but I can't get there yet.

For a single parameter you could use a Selection Criteria such as: Local NumberVar i; Local booleanVar bResult := FALSE; For i:=1 to UBound({?MyParm}) do ( if InStr({CI_Item.Category3},{?MyParm}[i])> 0 Then bResult := TRUE ); bResult

Wow, @DanBurleson now I'm embarrassed to add how I did it but oh well.... Basically, I created 10 formulas - one for each position of Category3 - then set the selection criteria to include any of them that met the parameter value(s). Worked no matter how many were in the field or where they were in the field.

Thanks @DanBurleson. Will run through it tomorrow. I think @ThereseLogeais was trying to suggest something similar, but it went over my head.

Make sure you get the latest version that corrected the spelling in the parameter.

@DanBurleson That worked like a charm. Thanks!