Report with two grouplevels

rbuser

Hi,

In a table I have stored Employees, Tasks and Time spent for the task and
some other details about the task.
I want to present it like:

Employee_name_1 Total time spent for all tasks:
Task_name_1
Taskdetails_1 + Time spent
Taskdetails_2 + Time spent
Taskdetails_3 + Time spent
Task_name_1 Total time spent:

Task_name_2
Taskdetails_A + Time spent
Taskdetails_B + Time spent
Taskdetails_C + Time spent
Task_name_2 Total time spent:

Employee_name_2
Task_name_1
Taskdetails_4 + Time spent
Task_name_1 Total time spent:

All tasks are group by employee and then grouped per taskname.
Tasknames are used across employees.

How can such a report be setup? I've tried to use grouping and such, but
I can't get the requested result.

nardmoseley

Try something like this...


1. Data Access

Create a DataSet ordered on the grouping fields.

Select *
From Employees
Order By EmployeeName, TaskName, TaskDetail


2. Report layout

Add a group on EmployeeName
Add a group on TaskName




-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Hello Nard,

Thank you very much, I made it far to difficult, where it is so simple.

Stef