Show interactive report single row view after submit

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.