Effort report

[razzo78]

Hi,
i want to make a report with a summary that contains the sum of all time effort that i had assigned to my elements.
How do i can do?

Thx.

[razzo78]

I have found a solution:

1: Create the following query:

SELECT SUM( t_objecteffort.EValue) as Hours
FROM
t_object, t_objecteffort, t_package

WHERE
t_package.Package_id in (#Branch#)
AND t_object.Package_ID = t_package.Package_ID
AND t_object.Object_ID = t_objecteffort.Object_ID

2: I added the query in a fragment template and the fragment template in a template