Keep getting details

[Michelangelo]

Hi,

I've created a report with a wizzard which was grouped on projectlevel. The details displayed every entry for all employees.

In another report I want to summarize these lists. So I created a copy of the first report. I added a group footer for on the employee field.

Structure:
- Report header
- Project header
- Employee header
- detail (empty)
- Employee footer
- Project footer
- Report footer

I moved the textboxes from the detail to the footer section of the employee group. Textbox: =Sum([Hours]) So the detail section is empty.

I want it to display the sum of the hours worked on the project for each employee. However it displays every record while there is nothing in the detail section.

Any solutions??

M.

 

[Michelangelo]

Found it,

In the original report I grouped on other field, and didn't remove them, so it wanted to sort on these (invisible) fields.

M