Oracle APEX Tutorial 3 - Drilldown Report Part 2- Video Training

By M&S Consulting (Kevin) on Jun 25th, 2009
Filed Under Technical Tips // Tags: ,

Introduction

This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a Drilldown Report. It is recommended that you review our APEX Tutorial Preparation and OEHR Sample Data Installation article if you do not have the OEHR sample data installed to your APEX installation. This section picks up after the first section ends.

Part 2 - Creating Order Items Report. Linking the reports together.

YouTube Preview Image

High Level Steps

1) Create and Test Order Item Report (0:38)
2) Create Item (2:58)
3) Link the Reports together (4:11)
4) Test Application (8:41)

Times in parenthesis are approximate start times for that step.

Notes and Resources.

Order of Creation

In this tutorial, and it’s second part, there are times when the order we create things may seem a bit contradictory to the end desired result. This is because in order for many of the automation and wizard-ed functions to work properly, it is necessary to create all the basic building blocks first, then re-arrange them and alter them to fit as originally desired.

Date / Number Formats

This tutorial employs altering the displayed format of some columns into more human readable form. This is for end human readability. For dates the format is fairly straightforward, however for some number types, the system employs a series of predefined mask and identifier characters to define to the application and the Oracle internals the desired format, which may not be easily understood when you see it in the format selector (In this case, the column to display order total).

Link explained

What we did is fairly simple. In the Order Items report, we designated that the data retrieved will be linked to a hidden item (P2_ORDER_ID). This hidden item is by it’s nature unseen by the user. We then setup the Orders report so that every displayed Order ID is a clickable link, and when clicked, will set the value of the hidden P2_ORDER_ID item to the value of the order ID, and call the Order Items report.

Bookmark and Share

Related Information:

  1. Oracle APEX Tutorial 3 - Drilldown Report Part 1- Video Training
    This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a drilldown report...
  2. Oracle APEX Tutorial 2 - Parameterized Report Part 1 - Video Training
    This Tutorial is a guided walkthrough of section 3 of the Oracle APEX Advanced Tutorials....
  3. Oracle APEX Tutorial 8 - Up and Downloading Files - Part 1 - Video Training
    Reports and data entry constitue the bulk of what most of these tutorials cover, and what many businesses need. However,...
  4. Oracle APEX Tutorial 2 - Parameterized Report Part 2 - Video Training
    This Tutorial is a guided walkthrough of section 3 of the Oracle APEX Advanced Tutorials....
  5. Oracle APEX Tutorial 6 – A Web Service – Part 2 – Video Training
    As the world moves forward, there is a higher need for more information. However, it is a near impossible task...
  6. Oracle APEX Tutorial 4 – Form Layout – Part 2 – Video Training
    APEX gives you a lot of power and flexibility with it's built in wizards. They are very good at creating...
  7. Oracle APEX Tutorial 7 - Stacked Bar Chart - Video Training
    Entering and retrieving data is all well and good, but sometimes a visual display of the raw numbers gives more...
  8. Oracle APEX Tutorial 5 – Check Boxes – Part 1 – Video Training
    Within APEX, there are a multitude of things you can use Check Boxes for, and many ways they can be...

Leave a Reply


Archives

Recent Comments

  • Kavitha Muniraj said: Hi, Could you please send a script which checks the status of forms and reports of oracle...
  • Siddharth said: Hey thanks a lot !! Have been lookin all over for this :) My PC may not be able t handle FlashBuilder...
  • Cyrex said: Hey man why I cant install Apex 4? is there anyone can help me.,?
  • sharanabasava said: ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; Sir,I...
  • Huub Vankan said: Thanks for this easy solution. Indeed strange that is does not work in the (x86) folder….

Calendar

July 2010
M T W T F S S
« Jun    
 1234
567891011
12131415161718
19202122232425
262728293031  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service