Print Page | Close Window

printing pay slip

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7646
Printed Date: 03 May 2024 at 2:19pm


Topic: printing pay slip
Posted By: gulli123
Subject: printing pay slip
Date Posted: 10 Sep 2009 at 2:13am
hi , i want to know is it possible to assing file name at runtime. i wanted to print pay slip for each employee from ms access database. the salary details will be present in SALARY table for all employees. i need to print the pay slip for each employee with employee code being the file name. for ex. 2035.rpt. this is because i need to mail the same to respective employees. is this possible in crystal reports. if so, please help me how i can achieve this. i am using vb as front end. Thanks in advance.
Regards
Ganesh


Replies:
Posted By: hilfy
Date Posted: 10 Sep 2009 at 9:37am
You would have to process the report separately for each employee.  There is no way that I know of inside crystal to "burst" a report into different files based on the data in the report.
 
However, there might be a third-party tool that would do this for you.  A good list of what's available can be found here - http://www.kenhamady.com/bookmarks.html - www.kenhamady.com/bookmarks.html
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: gulli123
Date Posted: 13 Sep 2009 at 11:35pm
hi,
appriciate your reply and  thanks ...i have managed to do this using export option.  while exporting i have used the recordselectionformula to filter for each employee record and create file name based on the selected records.
 
Regards
Ganesh

Posted By: ananddevelop
Date Posted: 19 Jun 2010 at 12:11am
i need to print payslip for muliple employees with muliple header and details could you kindly help me..

Posted By: rahulwalawalkar
Date Posted: 19 Jun 2010 at 12:25am
Hi
 
Please can you post some sample data to play around with, in meantime you can try doing this.
 
*Group By Employee No or Name to create Separate Group for Each Employee.
 
* Enter the header details .
 
*Details for the employee will be displayed in that specific group for employee
 
*Then got to Report--> Section Expert Select Employee Group Footer Check New Page After which will create separate page with details for each Employee with the details.
 
*In New Page After X+2 enter the following code Not OnLastRecord which will suppress any blank pages.
 
hope this is what you looking for
 
Cheers
Rahul


Print Page | Close Window