使用SQL PLUS快速开发ORACLE ERP报表

使用ORACLE PL/SQL代码可以快速开发Oracle ERP报表，可以节省使用Reports Butilder使用的忙烦，以下举例说明:

SET pagesize 500 linesize 400 echo Off feedback off heading on

TTI CENTER COL 50 "项目甲供货实供统计报表" Skip 3

COL "使用项目" FORMAT A15
COL "供货合同号" FORMAT A10
COL "材料供应商名称" FORMAT A50
COL "材料名称" FORMAT A50
COL "型号或规格" FORMAT A50
COL "单位" FORMAT A10
COL "实供数量" FORMAT 999,999,999.00
COL "实供单价" FORMAT 999,999,999.00
COL "实供合计" FORMAT 999,999,999.00
COL "供货日期" FORMAT A10

break On report On "使用项目" Skip 2

Compute Sum Of "实供数量" On "使用项目"
Compute Sum Of "实供单价" On "使用项目"
Compute Sum Of "实供合计" On "使用项目"

Compute Sum Of "实供数量" On report
Compute Sum Of "实供单价" On report
Compute Sum Of "实供合计" On report

Select cfv.project_name "使用项目",
       cfv.CONTRACT_NUMBER "供货合同号",
       cfv.META_VENDOR "材料供应商名称",
       cfv.MATERIAL_NAME "材料名称",
       cfv.UNIT_MEAS "单位",
       cfv.PRACT_QUANTITY "实供数量",
       cfv.CONTR_UNIT_PRICE "实供单价",
       cfv.PRACT_QUANTITY*cfv.CONTR_UNIT_PRICE "实供合计",
       to_char(cfv.MATERI_DATE,'YYYY-MM-DD') "供货日期"
From CUX_FIRST_METARIAL_V cfv
Order By 1;