i dont know it this could be help for you... if you would like to generate pay slip to all employee, your stored procedure or whatever you use..dont use parameter in your stored procedure, just a plain stored procedure, not a parametarize stored procedure..

Hi,
Thanks for ur replay,

I want to generate pay slip dynamically, ie i am placing some formula fields in my crystal report, then i am sending values to those formula fields through code behind(vb.net2.0), Here formula field can hold only one value.but i need to generate pay slips for all employees...............

Any idea plz...........

Thanks.

Hi,

Thanks for ur replay,

Here i am not passing any table to crystal report.All values i am passing to formula fields bcuz all fields are dynamic i am not using any database field directly in my crystal report.All calculations i am doing in code behind (earnings and deductions calculations) so in code behind i will get one dataset with all data to generate payslips(all dynamic data for all employees) but formula field can hold only one value ???

Any idea plz...........

Thanks.