Report Practical - Master Details Report

Report Practical - Master Details Report:

1 - CREATE A MASTER DETAILS REPORTS WITH THE FOLLOWING TABLES IN OE SCHEMA with parameter. e.g. ORDER_ID=2440
2 - IN THE ORDER ITEMS TABULAR REPORT ADD AN ITEM WHICH CALCULATE THE 

    UNIT_PRICE * QUANTITY. e.g. AMOUNT. with parameter. e.g. ORDER_ID=2440
3 - Sum up the Amount Item in the Order Item Tabular REPORT.

4 - Add a function which displays product name from product information table in the detail block.



Muhammad Abdullah Al Noor

Muhammad Abdullah Al Noor, An Oracle Apex Consultants and founder of Noors Technology (www.noorstech.com). Core Expertise : Database Administration, Oracle Forms and Reports Development, Oracle Apex Application Designer and Development, Linux Professional etc. Also the owner of TrainerBD Training and OraDemy E-Learning. WhatsApp +8801790721177

Post a Comment

Previous Post Next Post