We have an column in our DB with values from 0 to 9 representing different statuses (ID_ACTIVE, ID_FAILED, etc).
I did a View/Report and I can add an input control to select which statuses I want, but only in numeric form.
I would like to use a custom input control in the form of a multi select list with the ID_XXXX values.
Is that possible in an ad-hoc view or report?
If the data type is numeric, then unfortunately you do not have the list-of-values filter operators. You could consider changing the source data type from numeric to varchar/text. Sorry I cannot think of a better alternative.