Who's On?

	Membership:
	Latest: John Bonin
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5270

	People Online:
	Visitors: 294
	Members: 0
	Total: 294

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

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

6 Replies

1 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

John Henley

Posts: 3351

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

Deleted User

New Member Send Private Message

Posts: 0

7/17/2006 6:03 PM

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

John Henley

Posts: 3351

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 Send Private Message

Posts: 460

7/19/2006 5:17 AM

What version of Crystal were these created in?

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

John Henley

Posts: 3351

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 Send Private Message

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

Posts: 3351

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.