北京培訓(xùn)報表定制開發(fā)v2cuzboffice

1、本文檔以按城市和軟件銷售情況報表為例來定制報表報表樣例如下:鉆取后的報表如下:一、按城市和軟件統(tǒng)計銷售情況報表定制報表 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點開報表定制頁面參數(shù)用里面寫數(shù)字表示設(shè)置參數(shù)然后點運行然后點定制，報表如下然后重命名文件然后設(shè)定報表名稱和描述然后點添加新動作-設(shè)定數(shù)值-設(shè)定數(shù)據(jù)精度和格式然后添加柱狀圖和堆疊柱圖，點添加新動作-添加圖形展示-柱狀圖然后點添加數(shù)值序列然后點確定然后點以真實數(shù)據(jù)預(yù)覽看下剛剛添加的柱圖然后添加堆疊柱圖，添加方法一樣只是叫法不一樣下面看下具體步驟然后添加數(shù)值序列點添加點確定然后預(yù)覽下看看跟樣例報表還有哪些區(qū)別一是工具條的設(shè)置，一個是多一列 city_id下面設(shè)置下工具條，city_id 列一會做鉆取的的時候要用稍后再設(shè)置點 添加新動作-設(shè)置工具條把不需要顯示的部分點上 然后

6、點確定，第一張報表就暫時做好了，然后做第二張報表，最后在做鉆取設(shè)置二、銷售詳細信息報表定制報表 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 個參數(shù)其中參數(shù) 3 參數(shù)名字為：cityid驗證值為 1然后點運行修改列名然后點定制然后點模版文件重命名和設(shè)定報表名稱和描述然后點 添加新動作刪除和添加列-隱藏數(shù)據(jù)隱藏前 2 列數(shù)據(jù)后：然后設(shè)置單價和銷售金額兩列數(shù)值點添加新動作-設(shè)定數(shù)值-設(shè)置數(shù)據(jù)精度和格式然后合并單元格點確定點確定后合并列然后同樣的方法合并銷售員列點確定然后合并名稱列點確定然后設(shè)置工具條然后點確定后預(yù)覽報表跟樣例一樣三、鉆取設(shè)置然后再在報表管理里面找到第一張報表點界面修改點添加，開始鉆取設(shè)置然后點添加參數(shù)然后點添加，點確定鉆取就設(shè)置好了然后 city_id 列可以隱藏掉了，隱藏數(shù)據(jù)項操作跟前面

10、一樣。2 張報表就做好了 并能從第一取到第二張.效果如下：四、報表掛載報表文件定制好了要掛載到報表中展現(xiàn)這部分通過 sql 添加-insert into rpt_tab values ('33','報表培訓(xùn)',1,'','./common/tree.jsp?ispread=1','leftFrame','/report/common/notebus.jsp?1=1');-一級節(jié)點insert into rpt_tree values ('2012041600','test',0,'',1,'/style/common/report/node/0012.png','',33,0,'');commit;-節(jié)點insert into rpt_tree values ('2012041601','銷售情況',2012041600,'/bizman/common/resul