Print Page | Close Window

Dynamic payslips for multiple employees?

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3097
Printed Date: 02 May 2025 at 12:26pm


Topic: Dynamic payslips for multiple employees?
Posted By: bhappy
Subject: Dynamic payslips for multiple employees?
Date Posted: 05 May 2008 at 12:31am
Hi All,

I need to generate pay slips for multiple employees using Crystal Reports.I can able to generate pay slip for one employee.But I can't generate pay slips for multiple employees.Can any one tell me any idea plz..............

Thanks.

-------------
Thanks,
Aswath.


Replies:
Posted By: neojhols
Date Posted: 05 May 2008 at 12:52am
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..

-------------
help each other..

Posted By: neojhols
Date Posted: 05 May 2008 at 12:53am
just a simple select statement

-------------
help each other..

Posted By: bhappy
Date Posted: 05 May 2008 at 1:03am
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.


-------------
Thanks,
Aswath.

Posted By: BrianBischof
Date Posted: 05 May 2008 at 8:41am
So you're saying that you want VB.NET to pass a list of employees to Crystal Reports and then it prints from that list? If so, you could use VB.NET to create a comma delimited string of the employee numbers to print. Then assign this to the record selection formula of the ReportDocument class. I would use syntax similar to the following for the record selection formula:
{yourtable.EmployeeId} IN [1001, 2005, 3123]



-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: bhappy
Date Posted: 05 May 2008 at 8:52pm
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.


-------------
Thanks,
Aswath.


Print Page | Close Window