Who's On?

	Membership:
	Latest: Chris Radcliffe
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5187

	People Online:
	Visitors: 150
	Members: 1
	Total: 151

	Online Now:
	Jerry

New Topics

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

Report for Lawson HR User Fields/Field Codes (PADICT)

Sort:

You are not authorized to post a reply.

Author

Messages

John Henley

Senior Member

Posts: 3348

7/17/2006 12:32 PM

Sometimes it's necessary to see what field number(s) are used internally Lawson HR for which fields (including user defined fields) in order to know which FLD_NBR to select from HRHISTORY. This information is stored in PADICT.

Here are two reports I use to lookup the field numbers, one for standard fields, the other for user-defined fields.

You will need to 'Set Datasource Location' in Crystal to point these reports to your database.

Attachments

1719313592671.zip

mil0n023

Veteran Member

Posts: 63

7/17/2006 6:03 PM

Clicking the links prompt me to Log On....
Which user ID/passwd are we to use?

John Henley

Senior Member

Posts: 3348

7/17/2006 6:22 PM

You need to 'Set Datasource Location' in Crystal to point these reports to your database.

Shane Jones

Veteran Member

Posts: 460

7/19/2006 5:17 AM

What version of Crystal were these created in?

8 / 8.5 / 9 / 10 / 11
????????

John Henley

Senior Member

Posts: 3348

7/19/2006 1:00 PM

I honestly don't remember, but I think 10 or 11.
Are you having trouble opening them?

Kate Liamero

Veteran Member

Posts: 70

7/19/2006 1:11 PM

Having trouble opening these Get a login screen with CMS name walrus. Can't get a .rpt file only an htm file

Thanks
Kate

John Henley

Senior Member

Posts: 3348

7/19/2006 1:32 PM

Sorry about that...I forgot that I had Crystal Enterprise running on that server, so CE kept trying to open the .rpt files.

I've re-attached them in a .zip file.

You are not authorized to post a reply.