Skip to Content
0
Former Member
Apr 24, 2007 at 05:46 AM

Exclude values from multiple value parameter

33 Views

Post Author: absolute584

CA Forum: Data Connectivity and SQL

I'm creating an inventory report which displays all my items in inventory. In this report, I created a multiple value parameter (not range). I was able to use the basic syntax and display the values with "join({?Parameter}, chr(10))". However, I cannot seem to figure out how to EXCLUDE these items from the recordset. I was trying to use something in relation to SQL "Not In" but that doesn't work. I figured since Crystal has the function "IN" that my "Not In" would work but to my dismay, unless I used it incorrectly, it didn't work. Any thoughts or help?

Thanks in advance.