post/how-to-create-master-detail-with-interactive-grid-in-oracle-apex/

[utterances-bot]

Master Detail with Interactive Grid - Ontoor Blogs

https://blogs.ontoorsolutions.com/post/how-to-create-master-detail-with-interactive-grid-in-oracle-apex/

[SAMARTHSAGAR107]

I tried to developed MASTER DETAIL PAGE MANUALLY, In Detail Region, Master Detail Master Region ---> there is Nothing in LIST in ORDER_ID IG page item Master Detail Master Column ---> there is Nothing in LIST How to set Primary key as well as Foreign key relationship Very Difficult to Develope Master Detail Page Manually. Please help to do it. Thanks Mahendra samarthsagar107@gmail.com

[SAMARTHSAGAR107]

in version 22.1

[SAMARTHSAGAR107]

I am going to create Master detail page Manually, I don't like way to create automatically Master detail page. EMP TABLE (DETAIL PAGE) in MASTER DETAIL MASTER REGION --> Select , I cannot select Master Table Name in Version 22.1 what to do / how to select Table in MASTER REGION property . Thanks May be this big drawback while creating Master Detail Page Manually

Mahendra 9820401229 India

[ashishtheapexian]

Have you selected the master details for child report? Only after that you can select the column to filter data in child report.

[SAMARTHSAGAR107]

I tried to developed MASTER DETAIL PAGE MANUALLY 1) CREATE INTERACTIVE REPORT FIRST 2) FROM INTERACTIVE REPORT, SELECT DEPTNO OF DEPT TABLE 3) CREATE DEPT REGION OF DEPT TABLE 4) CREATE EMP REGION OF EMP TABE

In EMP Detail Region, Master Detail Master Region ---> there is Nothing in LIST in DEPTNO page item in EMP Region Master Detail Master Column ---> there is Nothing in LIST

Please help to do it. Thanks Mahendra samarthsagar107@gmail.com)

[SAMARTHSAGAR107]

in Oracle Apex,I have to do master details Page Manually for that how to do in brief Thanks Mahendra

On Fri, Jun 24, 2022 at 11:36 AM Ashish Sahay @.***> wrote:

Have you selected the master details for child report? Only after that you can select the column to filter data in child report.

— Reply to this email directly, view it on GitHub https://github.com/ashishtheapexian/BlogComments/issues/16#issuecomment-1165231253, or unsubscribe https://github.com/notifications/unsubscribe-auth/APF6N7NRVVGWGQULGPOLD4LVQVF4VANCNFSM5ZIVS7FQ . You are receiving this because you commented.Message ID: @.***>

[ashishtheapexian]

Both regions should be crated as Interactive Grid.

Steps: 1) Create One Grid on top of DEPT table 2) Create Another GRID on EMP table

Setup: 1) Go to EMP Grid (Detail) 2) Go master Detail Attributes 3) Select Master Region as DEPT 4) Got Detail Grid> FK column/Item 5) Select PK Column from PARENT Grid (DEPTNO)

Now Good to Go.

[ashishtheapexian]

Vikas has explained the Master detail, please checkout

https://www.youtube.com/watch?v=V3xUHRc48kk&t=603s&ab_channel=OntoorSolutions

[SAMARTHSAGAR107]

Hi Ashish, Happy Dipawali

1) I want to PRINT HEADER on report . COMPANY HEADER(Mahendra & Mahnedra) REPORT TITLE(Employee Master Report) DATE : 26-10-2022

                                          PAGE NO. : 1 / 5

---

2) On Development site, I created three report on Interactive Report and SAVED as with 3 different Name How to disable it on PRODUCTION site. and created 3 BUTTON & how to access on Button click.

Thanks & Regards

Mahendra

On Thu, Sep 8, 2022 at 4:22 PM Ashish Sahay @.***> wrote:

Vikas https://blogs.ontoorsolutions.com/authors/vikas-pandey/ has explained the Master detail, please checkout

https://www.youtube.com/watch?v=V3xUHRc48kk&t=603s&ab_channel=OntoorSolutions

— Reply to this email directly, view it on GitHub https://github.com/ashishtheapexian/BlogComments/issues/16#issuecomment-1240553170, or unsubscribe https://github.com/notifications/unsubscribe-auth/APF6N7N3FEXNITOP5BMOHODV5HAQXANCNFSM5ZIVS7FQ . You are receiving this because you commented.Message ID: @.***>