Parameter Fields Data Selection

[markcobb]

I am trying to build a report that relies on a Part Numbers. The user requires a Parameter field so that they can select either one part number, all part numbers or a range of part numbers, so far so good. However, they also want the ability to enter in the Parameter field something like JH* and for the report to retrieve all Part Numbers that start with JH. Is this possible to do in a Parameter field.


Many thanks in advance



Mark Cobb

 

[Naith]

You can use part-wildcard values in parameters by editing the Record Selection Criteria so that the parameter rule reads:

{Field} like {?Parameter}

Like ignores indexes.

Naith