Friday, August 3, 2012 Show interactive report single row view after submit APEX Tips and Tricks Here is how you can open interactive report single row view after page submit or page load. Example is based on my previous post Show detail report for IR single row view record and idea from Jim to show tabular form instead of report when go single row view. Unfortunately we did not get wizard created tabular form working on this case, but workaround is create so called "manual" tabular form. NOTE! in this example we use undocumented IR JavaScript function gReport.controls.row. This function may change or not exists in coming APEX versions. Comparing previous example change hidden item Px_CUSTOMER_ID Source Used: Only when current value in session state is null Source Type: Static Assignment (value equals source attribute) Edit in earlier post created dynamic action "Hide detail report" and add true action Action: Set Value Fire On Page Load: False Set Type: JavaScript Expression JavaScript Expression: null Selection Type: Item(s) Item(s): Px_CUSTOMER_ID Create new dynamic action. Select Advanced: Name: Go Single Row View Event: Page Load Condition: No Condition Action: Execute JavaScript code Code: gReport.controls.row($v('Px_CUSTOMER_ID')); Selection Type: None Go edit dynamic action and add another true action Action: Show Fire On Page Load: False Selection Type: Region Region: {select your report/tabular form region} Edit dynamic action and add condition type "Request=Expression 1" and enter to Expression 1 "GO_SINGLE_ROW" Next edit your page branch that lead backto same page and add to Request "GO_SINGLE_ROW". See working example.