This discussion is archived
1 Reply Latest reply: Oct 4, 2012 10:41 AM by user3027589 RSS

APEX report with multiple values for a single parameter

user3027589 Newbie
Currently Being Moderated
I have a user requirement where they want to be able to select multiple values for a single parameter that will act as a filter for a report. The possible values for a parameter can come from almost any master data Oracle eBusiness table. I don't want to just present the user with a LOV where they search down a list selecting what they want. That wouldn't be very practical for selecting part numbers from 1000's of rows. I also want the user to easily see what values they have selected. I thought about providing a button that would navigate to a multi-row form where they could record their values and use those values in the where clause of the SQL for the report, but that is a somewhat complex solution I have never tried before. Just looking for any helpful suggestions on how to do this. I'm working in the latest version 4 of APEX.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points