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?
TIA
Randy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only