In one of my project. i have a problem.
i want a Salary slip report. i use mail label. i want the report like

Name : mr X
Site   : Current SiteX

Site   Work(hrs)  Advance  Balance
-----   ------------   ----------- -----------
site1   10              100       500
site 2   2                50          10
.
.
Site n   5                   200     200
--------------------------------------------
Total  sum(Work)    sum()   Sum()


i use sql server as Db. i pass a datatable. the query to get ths datatable
will result like

currentsite      Name          Site    work advance Balance
------------------------------------------------------------
Current SiteX  MrX              Site1    10     100        500
Current SiteX  MrX              Site2    10     50          10
.
.
Current SiteX  MrX              Siten    10     100        500
Current SiteY  MrY              Site1     5        20         500


How will get multiple lable in mail label
or how will solve this
please help
 



Edited by sumu - 24 Feb 2010 at 1:41am