北京培训报表定制开发v2cuzboffice

1、本文档以按城市和软件销售情况报表为例来定制报表报表样例如下:钻取后的报表如下:一、按城市和软件统计销售情况报表定制报表 sql：select city_id,city_name,sum(nms) nms,sum(sla) sla,sum(report) report,sum(monitor) monitor,sum(uip) uip,sum(pasm) pasm,sum(cruiser) cruiserfrom (select ct.city_id,ct.city_name,(case when product_name = 'Ultra-NMS'then sum(o.pric

2、e*o.amount) else null end) nms,(case when product_name = 'Ultra-SLA'then sum(o.price*o.amount) else null end) sla,(case when product_name = 'Ultra-Report' then sum(o.price*o.amount) else null end) report,(case when product_name = 'Ultra-Monitor' then sum(o.price*o.amount) els

3、e null end) monitor,(case when product_name = 'Ultra-Uip'then sum(o.price*o.amount) else null end) uip,(case when product_name = 'Ultra_Pasm'then sum(o.price*o.amount) else null end) pasm,(case when product_name = 'Ultra-Cruiser' then sum(o.price*o.amount) else null end) crui

4、serfrom rpt_demo_orders o,rpt_demo_city ct,rpt_demo_product p,rpt_demo_customer cwhere o.customer_id(+) = c.customer_idand duct_id = duct_idand c.city_id = ct.city_idand o.sale_date >= 20120101and o.sale_date < 20130101group by ct.city_id,ct.city_name,duct_name ) a1group by city

5、_id,city_name点开报表定制页面参数用里面写数字表示设置参数然后点运行然后点定制，报表如下然后重命名文件然后设定报表名称和描述然后点添加新动作-设定数值-设定数据精度和格式然后添加柱状图和堆叠柱图，点添加新动作-添加图形展示-柱状图然后点添加数值序列然后点确定然后点以真实数据预览看下刚刚添加的柱图然后添加堆叠柱图，添加方法一样只是叫法不一样下面看下具体步骤然后添加数值序列点添加点确定然后预览下看看跟样例报表还有哪些区别一是工具条的设置，一个是多一列 city_id下面设置下工具条，city_id 列一会做钻取的的时候要用稍后再设置点 添加新动作-设置工具条把不需要显示的部分点上 然后

6、点确定，第一张报表就暂时做好了，然后做第二张报表，最后在做钻取设置二、销售详细信息报表定制报表 sql：select rownum row_num,order_id, city_name,company_short,sales_name,product_short, sale_date, price, amount,p_acount, descrfrom (select o.order_id,o.customer_id,o.sales_id,duct_id,c.city_id,ct.city_name, pany_short,s.sales_name,duct_short,

7、substr(o.sale_date,0,4)|'年'|substr(o.sale_date,5,2)|'月'|substr(o.sale_date,7,2)|'日' sale_date ,o.price, o.amount,o.price*o.amount p_acount, o.descrfrom rpt_demo_orders o,rpt_demo_customer c,rpt_demo_city ct,rpt_demo_product p,rpt_demo_salesswhere o.customer_id = c.customer_id

8、and c.city_id = ct.city_idand duct_id = duct_idand o.sales_id = s.sales_idand o.sale_date >=20120101and o.sale_date <2-0130101and o.sale_date =sale_dateorder by 13 desc) awhere customer_id = customer_idand city_id = 1and sales_id = sales_idorder by company_short, sales_name,product_s

9、hort点开报表定制页面有 3 个参数其中参数 3 参数名字为：cityid验证值为 1然后点运行修改列名然后点定制然后点模版文件重命名和设定报表名称和描述然后点 添加新动作删除和添加列-隐藏数据隐藏前 2 列数据后：然后设置单价和销售金额两列数值点添加新动作-设定数值-设置数据精度和格式然后合并单元格点确定点确定后合并列然后同样的方法合并销售员列点确定然后合并名称列点确定然后设置工具条然后点确定后预览报表跟样例一样三、钻取设置然后再在报表管理里面找到第一张报表点界面修改点添加，开始钻取设置然后点添加参数然后点添加，点确定钻取就设置好了然后 city_id 列可以隐藏掉了，隐藏数据项操作跟前面

10、一样。2 张报表就做好了 并能从第一取到第二张.效果如下：四、报表挂载报表文件定制好了要挂载到报表中展现这部分通过 sql 添加-insert into rpt_tab values ('33','报表培训',1,'','./common/tree.jsp?ispread=1','leftFrame','/report/common/notebus.jsp?1=1');-一级节点insert into rpt_tree values ('2012041600','test',0,'',1,'/style/common/report/node/0012.png','',33,0,'');commit;-节点insert into rpt_tree values ('2012041601','销售情况',2012041600,'/bizman/common/resul