Group Footer?Detail Section?

[AlreadyLost]

Okay, I want to sum up the total of assigments by employee. Here is the layout of my report

Group Header (group by department)
Detail section: list all employee and their id that are associated with the department group.

I have to add in another field that will calculated the total store assign to each employee. So I created a running total field to count store assgined. Then I place it in the detail section and guess what happen, I have the same employee and their id listed multiple times with running total count 1,2,3,4,5,6...

Then I wanted to sum the running total and place it in the detail section but someone told me that you cannot sum running total.

I try moving the department group, employee , employee id to the group footer..and Guess what happen, it only show me the last record.

How can I display all the employee and the total store assigne to each employee? What section of the report should I put these field?

 

[synapsevampire]

I'm guessing that you don't have much experience with databases, as this looks like a row inflation concern.

You'll be better off to post technical information then text descriptions:

Crystal version
Database/connectivity used
Example data (show the tables and data within)
Expected output

This will certainly need clarification:

"that will calculated the total store assign to each employee"

-k

 

[kskid]

Just insert another group by employee and then insert a summary count of assignments by employee.

-lw

 

[AlreadyLost]

Can I used the summary count field and divided by a number?

 

[kskid]

Yes, you can.

However, it would be much more helpful if you had some sample data along with the expected results you are trying to achieve.

-lw

 

[AlreadyLost]

I think I figure it out how to divide by. Thanks anyway..