Newbie help with Parameter Search formula

[tthai826]

Need to search the part master for part numbers that end with a 1028-01A, 1028-02A, 1028-01B, 1028-02B, or W (ex: 234293W)

I'm running CR 8.5, any help plz?

 

[StephHansen]

Create a new parameter called Part, choose the type of format and click the "Allow Multiple Values" Checkbox.

Then, go to the Select Expert and say PartNumbers is one of {?Part}. CLick OK

This will then prompt you to enter the part numbers when you run the report.

Hope this helps!

Stephanie

 

[kimchavis]

Try this in your selection criteria:

Right ({partnumberfield}, 1) = "W" or Right ({partnumberfield}, 8) = ["1028-01A", "1028-02A", "1028-01B", "1028-02B"]