Click here to Skip to main content
15,899,632 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,
i have a report that shows Monthly attendace of employee..
Each day has 2 or more than two entries for a employee , 1 when he signin and the other when he leaves
i have to use Group by Days like this,

Note:
INOUT 1 = TimeIN
INOUT 2 = TimeOut

TID ATTENDANCEDATE EMPID INOUT

01 nov 2010

37219 2010-11-01 09:01:00.000 0000000001 1

37109 2010-11-01 18:02:00.000 0000000001 2

02 nov 2010

37219 2010-11-01 09:01:00.000 0000000001 1

37109 2010-11-01 18:02:00.000 0000000001 2


37219 2010-11-01 09:01:00.000 0000000001 1

03 nov 2010

37219 2010-11-01 09:01:00.000 0000000001 1

37109 2010-11-01 18:02:00.000 0000000001 2


i have use =Fields!AttendanceDate.Value in Parent Group and Included Group Header

The Problem is the report is only showing 1 record in each group..
please tell me how i can do this?
Posted
Updated 9-Mar-12 0:25am
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900