Who's On?

	Membership:
	Latest: Pramod Chandra
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5243

	People Online:
	Visitors: 71
	Members: 0
	Total: 71

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Creating a PA213 report in Crystal Reports...HELP!

5 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

Sarah

Advanced Member

Posts: 33

5/24/2011 2:02 PM

We moved to Lawson in 2006 and the PAEMPPOS table has history back to 12/26/2006 but we have a need for data going back prior to 2006 and the HRHISTORY,PERSACTHIST, and PRRATEHIST all have the history from our previous HR\Payroll software.

My issue is how to display one clean row per effective dated change instead of showing several rows for every history action. Could I create a derived field in Crystal Rpts like DEPT=HRHISTORY.FLD_NBR="15" so it would only display the ee's department for that effective dated row instead of showing a row for every fld_nbr?

I know this is more of a Crystal Rpts question than a Lawson question but thought I would throw it out there and see if anyone else has done something like this.

Thanks for any help or suggestions on this.

S

Sarah

Advanced Member

Posts: 33

5/24/2011 2:19 PM

I may be able to do this with grouping in Crystal rpts but it's still not as clean looking as I would like. Any suggestions are appreciated.

Thank you,

S

Terry Wier

Basic Member

Posts: 13

6/2/2011 6:18 PM

Sarah,

The Dashboard Gear Lawson HR Reporting Tool Kit (a data warehouse) will make this type of reporting very easy. Check out our website or feel free to give me a call.

Terry

Terry Wier
VP Sales Dashboard Gear (a Lawson Software Partner)
www.dashboardgear.com
763-208-9937 office
952-454-2899 cell
terry.wier@dashboardgear.com