At first, I had created an item P31_JOB_CATEGORY that was a radio button. Upon selecting a value for the radio button, a report was generated. The query is as follows
select a, b, c
from Table A
where A.Job_Category = :P31_JOB_CATEGORY
This gave me the desired report. Now I want to change the radio button to a shuttle list so multiple values can be selected for the job category and generate a the report accordingly. Instead of one value, I can have 2, 3, or all. How would I alter my query to change this? would I have to use an array. I was thinking some type of "Where....In.." clause.