看下面的解决方案可以帮到你

http://forums.asp.net/t/1798215.aspx?attendance+system+monthly+base [ ^ ]

创建每月出席报告 [ ^ ]

I have 2 table
first table is like this

Empid Name Desgnation
1 ab cd
2 bc aa
second table is

Empid status Doc

1 Present 2014-05-01

2 Absent 2014-05-01

1 Present 2014-05-02


I want to desplay my result like this

Empid name 1 2 3 4 5 6 7 ...............31

1 ab present Present

2 bc Absent

please help

see the following solution may help you
http://forums.asp.net/t/1798215.aspx?attendance+system+monthly+base[^]
Create Monthly Attendance Report[^]