AnySQL.net

    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软件.