Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: printing pay slip Post Reply Post New Topic
Author Message
gulli123
Newbie
Newbie


Joined: 10 Sep 2009
Online Status: Offline
Posts: 3
Quote gulli123 Replybullet Topic: printing pay slip
    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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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 - www.kenhamady.com/bookmarks.html
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
gulli123
Newbie
Newbie


Joined: 10 Sep 2009
Online Status: Offline
Posts: 3
Quote gulli123 Replybullet 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
IP IP Logged
ananddevelop
Newbie
Newbie
Avatar

Joined: 19 Jun 2010
Location: India
Online Status: Offline
Posts: 2
Quote ananddevelop Replybullet 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..
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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


Edited by rahulwalawalkar - 19 Jun 2010 at 12:26am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.