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

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
Chris Martin	825

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

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.

Deleted User

New Member

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: 3366

New Poster

Engaged Reader

Avid Reader

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

Posts: 3366

New Poster

Engaged Reader

Avid Reader

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

Posts: 3366

New Poster

Engaged Reader

Avid Reader

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.