Report Practicals - Tabular Report

Create Tabular Report:

SCHEMA : OE.

1 - CREATE A REPORT WITH THE FOLLOWING QUERY :

SELECT PRODUCT_NAME,CATEGORY_ID,SUPPLIER_ID,
PRODUCT_STATUS,LIST_PRICE,MIN_PRICE
FROM PRODUCT_INFORMATION;

2 - ADD A PARAMETER (MODIFY TO PARAMETER BASED REPORT).

SELECT PRODUCT_NAME,CATEGORY_ID,SUPPLIER_ID,
PRODUCT_STATUS,LIST_PRICE,MIN_PRICE
FROM PRODUCT_INFORMATION
WHERE SUPPLIER_ID=:P_SUPPLIER_ID;

3 - ADD NEW COLUMN TO THE QUERY : PRODUCT_ID

SELECT PRODUCT_ID,PRODUCT_NAME,CATEGORY_ID,SUPPLIER_ID,
PRODUCT_STATUS,LIST_PRICE,MIN_PRICE
FROM PRODUCT_INFORMATION
WHERE SUPPLIER_ID=:P_SUPPLIER_ID;

AND ADD TO THE REPORT.