display crystal Report. in following Format .

See more:

SQL-Server

SQL-Server-2008

Hi guys,

i have table like below ,

AttandanceDate Month Year EmpName

1 Jan 2011 AJ
2 Jan 2011 Manish
3 Jan 2011 Sagar
4 Jan 2011 Kedar
5 Jan 2011 Swapnil
6 Jan 2011 Santosh
7 Jan 2011 Namrata
8 Jan 2011 Sandy

I need output like below :-------

EmpName |AttandanceDate: | 1 | 2| 3| 4| 5| 6| 7| 8|

AJ
Manish
Sagar
Kedar
Swapnil
Santosh
Namrata
Sandy



also date increases column also need to increase,
Pls help me its very Urgent .Thanks in advance...:(