>I am having problems getting a report based on a parameterized view to pull the correct data. I want the view to pull data based on finding the status code for that record in a list of codes selected by the user.
>
>I am using the 'IN' operator and in the example field of the filter page, I entered ?gcClientStatus, which is declared PUBLIC and defined in the BeforeOpenTables event of the data environment of the report.
>
>After declaring and defining gcClientStatus, I call a form which presents a multi-select list of all valid client status codes. The value of gcClientStatus is changed inside this form to correspond with the status codes selected. I have tried placing single and double
>quotation marks around each item as they are added to gcClientStatus, de-lineating with a comma, (i.e. "ACTIVE ","INACTIVE ",...) and I get nothing. If I leave the quotation marks off (i.e. ACTIVE , INACTIVE
>,...), I get only the records that match the first code in the list. I know it's something simple, but I have been beating my head against the wall with no results. Any ideas?
>
You might try INLIST instead of IN, which doesn't work for lists properly...