Hello,

How I can make sum (totals) on the all groups of the report.

Thanks,
Ovidiu

Let us assume you have the following query:

select deptno, job, ename, sal from emp
order by deptno, ename

You want to have a break for each department (deptno) and for each job within this department. You also want to show the total salary (sal) for each department and job.

On the layout tab page you can define a "Break" for the deptno and sal columns. For the sal column you can define a "Sum per Break" to display the sum of the salaries for each job and for each department.

You can also define a "Sum per Break & Report" to additionally show the total sum of the salaries for the entire report.

------------------
Marco Kalter
Allround Automations

Thanks.

It works.

Ovidiu

[quote]Originally posted by mkalter:
Let us assume you have the following query:

select deptno, job, ename, sal from emp
order by deptno, ename

You want to have a break for each department (deptno) and for each job within this department. You also want to show the total salary (sal) for each department and job.

On the layout tab page you can define a "Break" for the deptno and sal columns. For the sal column you can define a "Sum per Break" to display the sum of the salaries for each job and for each department.

You can also define a "Sum per Break & Report" to additionally show the total sum of the salaries for the entire report.

[/quote]