DataReport的GROUP功能可以对左边的指定列进行重复值合并, 对于右边的列无能为力, 当我们在查询员工表时, 页面显示如下.


EMPNO ENAME JOB SAL DEPTNO
7782 CLARK MANAGER 2450 10
7839 KING PRESIDENT 5000 10
7934 MILLER CLERK 1300 10
7369 SMITH CLERK 800 20
7566 JONES MANAGER 2975 20
7902 FORD ANALYST 3000 20
7499 ALLEN SALESMAN 1600 30
7521 WARD SALESMAN 1250 30
7654 MARTIN SALESMAN 1250 30
7698 BLAKE MANAGER 2850 30
7844 TURNER SALESMAN 1500 30
7900 JAMES CLERK 950 30

    也许我们更希望, 最右边的部门号字段进行复值合并, 得到如下输出.


EMPNO ENAME JOB SAL DEPTNO
7782 CLARK MANAGER 2450 10
7839 KING PRESIDENT 5000
7934 MILLER CLERK 1300
7369 SMITH CLERK 800 20
7566 JONES MANAGER 2975
7902 FORD ANALYST 3000
7499 ALLEN SALESMAN 1600 30
7521 WARD SALESMAN 1250
7654 MARTIN SALESMAN 1250
7698 BLAKE MANAGER 2850
7844 TURNER SALESMAN 1500
7900 JAMES CLERK 950

    在DataReport中现在可以做到了, 只需要指定要进行合并处理的列, 用如下标记.

WEBCHART.MERGE_n=col1|col2|…

    如果你有网页查询系统要开发, 可以试试免费的DataReport软件.