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.

Karen Page

As VP of Sales & Marketing, Karen has been helping to break sales records since 1994! That’s almost 30 years of award-winning sales, helping to build Big Hairy Dog as a leading POS Software and Service provider…worldwide. She has a degree in fine arts (with a minor in business) from the University of Oregon, and with three amazing children and saint of a husband, Karen is still loving life in the Northwest—where she works from home in the Portland, Oregon area.

Her favorite pastime is tailgating at college football games with friends and family. Go Ducks!

Karen Page

As VP of Sales & Marketing, Karen has been helping to break sales records since 1994! That’s 25 years of award-winning sales, helping to build Big Hairy Dog as a leading POS Software and Service provider…worldwide. She has a degree in fine arts (with a minor in business) from the University of Oregon, and with three amazing children and saint of a husband, Karen is still loving life in the Northwest—where she works from home in the Portland, Oregon area.

Her favorite pastime is tailgating at college football games with friends and family. Go Ducks!