SELECT “INVENTORY_V”.”ALU”, “INVENTORY_V”.”DESCRIPTION1″, “INVENTORY_V”.”DESCRIPTION2″, “INVENTORY_V”.”VEND_CODE”
FROM “CMS”.”INVENTORY_V” “INVENTORY_V”
WHERE “INVENTORY_V”.”VEND_CODE”=N’BARBOK’ (the ?=N? should simply be ?IN?)
ORDER BY “INVENTORY_V”.”DESCRIPTION1″, “INVENTORY_V”.”DESCRIPTION2″, “INVENTORY_V”.”ALU”
This is standard SQL generated from crystal, and instead of using WHERE X = Y, it must be entered as a formula WHERE X IN Y. After that the report registers successfully and allows parameters to be used.