How to pass the column value in the interactive report to another report?

Today's video I will pass the deptno of the department report (interactive report) to the deptno of the emp.

[@fgl2012]

Very useful. Clear and precise. Well done!

[@weililiu2119]

Glad it was helpful!

[@noahhebert7571]

Great tutorial, however when I use paging on the top table, the Dep3 no longer updates. In my instance my top table will contain 3000 rows, and I will need pagination. Guidance?

[@weililiu2119]

Thank you for asking. I tried your scenario, It is working. I think maybe you missed some setting. I have 2 items, P3_DEP is for report department,P3_DEP3 is for report emp. when I click the row and column deptno, in the top report department, I have a dynamic action: Get_dept_no when: Click Selection Type: Jquery Selector Jquery Selector:#my_dept_id table:eq(1) tr:not(:eq(0)) td[headers="deptno_id"] Action :Execute Javascript Code $s(('P3_DEP3'),$(this.triggeringElement).text()) Affected Elements: Items P3_DEP3 You should create another dynamic action：Refresh_3 when: Event: Change Selection Type: Items Items:P3_DEP3 Action: refresh Selection Type： Region Region：EMP

[@jorgebernal837]

HI I need to submit the value for the item P3_DEP3? because I have the same example.. and I can see in the page de value for apex_item but in session still missing..! So the EMP report show not found, but when run the report script show the recordset.. any ideas? thanks a lot

[@weililiu2119]

Not submit p3_dep3. when p3_dep3 changes, refresh the emp report. It is partially refreshing using dynamic action.

[@jorgebernal837]

@@weililiu2119 ok but I need the P3_DEP3 item because in my second report Select * From table_details Where dep_id = :P3_DEP3 When the P3_dep3 change I need to show the details... Thanks a lot..

[@weililiu2119]

Yes, you are correct. When user selects dept report specific row , get specific dept no in that row and pass to the item p3_dep3, when the p3_dep3 changes, then refresh emp report. Need to submit p3_dep3 in the report emp. @@jorgebernal837

[@jorgebernal837]

@@weililiu2119 Thanks for your help... could you give me an example the best way to submit ape_item value? I can use javascript or need to perform set value PL/SQL ? thanks a lot

[@Mohammed-kh4lj]

Is there a way to pass column value to page item?

[@weililiu2119]

This program is pass dept no in the dept report to page item p3_dept_no

[@mjamilkhan1981]

working ok but in latest version Execution Event Scope Must be Dynamic

[@jannahinchliff8420]

Hi, I've just tried to implement this. It mostly works - I click on a department number and it goes into the dep3 box and refreshes the second report, but when I refresh it doesn't filter the department id, it just refreshes the report without changing it. Which part am I missing?

[@weililiu2119]

I understand your question. P3_DEP3 item is for EMP report partial refresh not for DEP refresh report in this example. I put the item P3_DEP3 visible not hidden only for people understand Clearly how it worked. If you want the DEP report fresh when P3_DEP3 changes, you can add a dynamic action when P3_DEP3 changes then refresh the DEP report. Thanks for you question.

[@jannahinchliff8420]

@@weililiu2119 sorry that's not what I mean. I mean when I click on the dep report, the emp report refreshes but the information in it isn't filtered to the department number that is shown in the P3_DEP3 box

[@weililiu2119]

I think you didn't add the condition clause in the emp report source SQL query , Please see below select EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO from EMP where DEPTNO=:P3_DEP3 or :P3_DEP3 is null Then set 'page item to submit': P3_DEP3 @@jannahinchliff8420

[@markangellotti893]

Why is a 'where' SQL statement needed in the Department region?

[@weililiu2119]

Not necessary. Depends on your situation

[@arfaatshaikh2452]

is it possible to fetch the data of a master details region page to the master page, but only the selected data.

[@weililiu2119]

Could you give me specific detail ? Thank you.

[@arfaatshaikh2452]

​@@weililiu2119 like my requirement is . mainly i used Interactive Report and Form for Company_details. Under that form page i just created a grid region which contain the detail of employee working in that company. So my aim is like when i select just a company on IR Report it should fetch the records which are present into grid.

[@weililiu2119]

@@arfaatshaikh2452 You can create page item Pxx_companyID in detail page and the type as 'hidden' . In master page, that is company page, under the IR report, column 'company_name', set the type as link, then link to detail page, pass the parameter companyID to Pxx_companyID(xx representing the detail page number). Another, In detail page, IG report SQL, should add where condition , companyID=:Pxx_companyID. Hope it is helpful for you. You can try, Thanks for asking.

[@mdhassanahmed7079]

Is there any way to pass a "*page item*" value to a "report column"?

[@weililiu2119]

dynamic action: Action: set value, PL/SQL expression: page item,(eg, :P1_item) submit: P1_item affected column: report column

[@inamhusain]

Thanks Weilli,

[@mohdsalmeen590]

Thanks

[@inamhusain]

please can you advise for this java script code source ?

[@gmorales73]

Please

[@weililiu2119]

Get_dept_no When: Click Selection Type:jQuery Selector jQuery Selector：#my_dept_id table:eq(1) tr:not(:eq(0)) Action：Execute JavaScript Code： $s(('P3_DEP3'),$(this.triggeringElement).find('td[headers="deptno_id"]').text()) Affected Elements: Selection Type: Items Items: P3_DEP3

[@ora600600]

Thanks a lot!

[@deencrypt8041]

how to pass only when click first column

[@weililiu2119]

If you want to click first column, you can try this below. A little change: Dynamic Action: when Event:click Selection Type: Jquery Selector Jquery Selector: #my_dept_id table:eq(1) tr:not(:eq(0)) td[headers="deptno_id"] Action: Execute Javascript:$s(('P3_DEP3'),$(this.triggeringElement).text()) Hope it is helpful for you.

[@deencrypt8041]

@@weililiu2119 i try to jQuery Selector #tn_emp_by_job table:eq(1) tr:not(:eq(0)) td:not(:has(input[type="checkbox"])) but Execute Javascript: $s(('P76_TN_JOBKEY'),$(this.triggeringElement).find('td[headers="JOB_KEY"]').text()) is not working Is there a way to solve it?

[@inamhusain]

I am trying on 21.2.1 not working,

[@weililiu2119]

It should be working