4 Replies Latest reply on Oct 5, 2012 1:17 PM by jfosteroracle

    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!