Apex V 19.2
I have 2 interactive reports 1 is the master, the other is the detail.
I have it setup so the detail is populated when a link column is clicked in the master.
I did this by following these instructions (Thanks Scott!):
Scott Wesley Member Posts: 6,171 Gold Crown
Aug 8, 2018 1:03AM edited Aug 8, 2018 1:03AM
A number of ways, here is one
Create hidden item: P1_DEPTNO
In your Dept region, make Deptno a Link column
Set the link target as url: javascript:$s('P1_DEPTNO, #DEPTNO#);
Set the link text as: #DEPTNO#
Create on change dynamic action on P1_DEPTNO
Add action to refresh Emp report
In your Emp region, set Page Items To Submit: P1_DEPTNO
I'd like to automatically populate the detail report using the link column from the first row when the user clicks a Search button to populate the master report.
Also, I'm giving users the option to use the built in sort options from the action menu, so ideally the detail grid would refresh to show the detail related to the 1st row whenever the user resorted the master.
How would I get the value of the link column in my first row?
I'm assuming once I have the value of the link set in my page item I can refresh the detail report after the master report is refreshed.