4 Replies Latest reply: Oct 5, 2012 8:17 AM by jfosteroracle RSS

    change report results with select list using dynamic action

      This is one of those situations where if I could figure out the right search terms to use, someone else must have asked this question in the past.

      I have a report with a SQL query with a condition based on a select list on the same page. So I have a select list - :P177_FISCAL_YEAR

      My query for my report is:

      select md_id, display_name, description
      from media_tbl
      where fiscal_year = :P177_FISCAL_YEAR

      When a person makes a selection on the select list (:P177_FISCAL_YEAR), I would like the report to update without having to submit the page. I was hoping I could do something like this using a dynamic action but haven't figured a way to do it.

      Thanks in advance!