This discussion is archived
4 Replies Latest reply: Oct 5, 2012 6:17 AM by jfosteroracle RSS

change report results with select list using dynamic action

jfosteroracle Newbie
Currently Being Moderated
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!

John

Legend

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