新手求助report主从显示问题

Question

比如说显示一个组织里所有部门和部门里的所有员工工资信息，并按部门显示小计工资小计值，最后还有个合计值
我现在做成这样了，用主从关系做的，主group里加了个求小计的sum列org                   dep                       user                       moneyxxxx                 xxxxxx                   xxxxx                      xxxxxxx     
                                              xxxxx                      xxxxxxx
                                              xxxxx                      xxxxxxx
                                                                         小计    xxxxxxxx
                       xxxxxx                 xxxxxx                     xxxxxxxx
                                              xxxxxx                     xxxxxxxxx
                                                                          小计   xxxxxxxxx   
---------------------------------------------------------------------------------------
                                                                          合计   xxxxxxxxx可客户要求每条数据都要显示org，dep信息，也就是做成这样org                   dep                       user                       moneyxxxx                 xxxxxx                   xxxxx                      xxxxxxx     
xxxx                 xxxxxx                   xxxxx                       xxxxxxx
xxxx                 xxxxxx                   xxxxx                       xxxxxxx
                                                                         小计    xxxxxxxx
xxxx                 xxxxxx                   xxxxxx                     xxxxxxxx
xxxx                 xxxxxx                   xxxxxx                     xxxxxxxxx
                                                                          小计   xxxxxxxxx   
---------------------------------------------------------------------------------------
                                                                          合计   xxxxxxxxx
刚接触不久，弄不出来，帮帮忙啊各位 

Answer 1

可以用rollup实现
group by rollup(org,dep ,user)     

Answer 2

-- TRY IT ..
SELECT ORG,DEP,USER,   
       DECODE(GROUPING(ID),1,'合计',ID) ID,   
       SUM(MONEY) MONEY
  FROM TABLE_NAME   
 GROUP BY ROLLUP(ORG,DEP,USER);

Answer 3

FYI:
http://topic.csdn.net/t/20060628/13/4848078.html