Single Article

Show interactive report single row view after submit

Category APEX 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"

Application process attributes

 

Next edit your page branch that lead backto same page and add to Request "GO_SINGLE_ROW".

Application process attributes

 

See working example.

Social Buttons

Comments

  • Q_DUDE 19 May 2014  

    Very Nice

    Very helpful

        

Global Right Column

Search

Archives

Subscribe in a Reader