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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement