Hello.  You are on the right track.  Let me see if I can help you complete this aspect of the report.  The field that identifies if the part number is Active, On hold or Inactive is the Hold field in the Inventory table.  Each part number has either a value of 0 if the item is Active, 1 if the item is On hold, or 2 if the item is Inactive.  So, if you need to get only Active part numbers to print, you will have the add a formula in the Record Selection that says:

{INVENTORY.HOLD} = 0

This formula can be added simply by right clicking an open white area of your report, select Report, Selection Formula, Record.  You can use it by itself (if you have no other criteria) or by adding the "and" syntax to make this part of your existing formula.  Once the above criteria is added to the Record Selection Formula your report will only show items with an Active status.  

You can change the formula if you wish to:

{INVENTORY.HOLD} = 1

so that only items that are in a Hold status will print.  You can have a copy of the same report with different Hold values within the Record Selection Formula so you can switch between Active and Hold status if you wish.

Hope this helps.

That is exactly what I needed!  Thank you SO much! :D