Oracle APEX Interactive Report Column Hyperlinks & Variables

0
votes

I'm using APEX 5 for the first time and trying to link users to the same page from an interactive report column.

The page being linked to will display different data, depending on which row user clicked.

I don't know what data to depend on to generate the new page, my thoughts are to write (a href) statements but not sure how variables are supposed to be stored this way.

Any advice or help would be greatly appreciated!

1
oracleoracle-apexoracle-apex-5oracle-apex-5.1

1 Answers

1
votes

Wrong approach, in my opinion.

You should have done this:

  • create a new page
  • choose the "Report" page type
  • choose "Report with Form on table"

It'll create both Interactive Report and a "linked" Form which will be used for the purpose you described. You don't even have to write a single line of code, Apex will do everything for you. You'd just click the icon at the beginning of the Interactive Report row, and it'll lead you to the Form and display values related to that very row.