Oracle APEX - Build Your Own Enhanced Nested Report

With lots of feedback and suggestions - which inspired me to dig further into Customized Nested Report and see how we can enhance this further.





So, purpose of this blog is to highlight you how you can further enhance Customized Nested Report. I have tried to add following new things to enhance custom nested reports capabilities. You can try and design your own nested report the way you want. These are just couple of examples that I have created for demo purpose.
  • 3 & 3+ level of nesting with Classic Report
  • Different templates of nested classic reports
    • Classic Report with Badge Template
    • Classic Report with Comments Template
Download full application and try it in your own environment. Please note that, it requires default tables EMP & DEPT with some valid data.

Working Demo
  • 2 Level Nested Report
  • 3 & 3+ Level Nested Report
  • Nested report as Badge View
  • Nested report as Comment view


Please note that, application and code is build under APEX 19.2 version and tested in Chrome browser. Feel free to drop your feedback.

Hope this helps!

Regards,
Jaydip Bosamiya
jbosamiya@gmail.com

Comments

  1. HI. HOW ARE YOU.. SIR I NEED DATA SAVE IN TABLE THROUGH DYNAMIC ACTION. BUT INTERACTIVE GRID LOAD DATA IN APEX_COLLECTION FROM QUERY.
    AND I USER DROP DOWN IN LIST AND UPDATE ON-CHANGE IN DROPDOWN TO UPDATE COLLECTION RECORD AND FINALLY CLICK ON SAVE BUTTON..

    ReplyDelete
    Replies
    1. Hello Devil Eyes, can you please prepare your example on apex.oracle.com and I will see what I can help you further? I am sure the question is not related to this blog.

      Delete
  2. Hello Sir, this is really nice article and thanks for posting. I have similar requirement when in my case, I need to show a detailed report for each header record in a interactive or classic report, and also, by default all the detailed reports should be visible for all the header records at the time of report loading. Could you please help me in achieving this..

    Thanks,

    ReplyDelete

Post a Comment

My photo
Jaydip Bosamiya
I am Oracle APEX Consultant, Blogger and Integrator. All-rounder in building small, medium and enterprise applications. Extensive knowledge in various area of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)

Popular posts from this blog

Oracle APEX - Interactive Report - Scrollbars on Top

How to create your own customized nested report regions using jQuery

Oracle APEX - Warn unsaved changes for custom fields