SQL PARAMETERS IN V9 REPORT VIEWER WITH CRYSTAL REPORTS

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.