Search code examples
oracle-apexoracle-apex-5

APEX 5: Make a report cell clickable and pass values

Just got started on APEX 5 and can't seem to figure out how to make cells in an Interactive Report clickable. What I'm trying to achieve is something like this:

Let's say I have a report on Page 1:

enter image description here

I want to be able to click on any cell in Column 2 and 3, and it should open a new page and show a list of items that made up that number, something like this:

enter image description here

I understand how dynamic actions work and how I can pass values but I just can't figure out how I can hyperlink or make the cells clickable, to set up any dynamic actions.

Solution

  • You can make the Column Type a Link and under Link Attributes, define the target page and set the items or filter report accordingly. You can have the Link Text as #COLUMN_NAME#.