I am trying to create a couple crystal reports that include a userfield and I am lost. I thought they were in HRUSERFIELDS but that table has no link to employee numbers.

What am I missing - anyone had luck with this?

Shane

HREMPUSF contains the company/emp nbr/key user field info

Mapping would be something like this:

(EMPLOYEE - HREMPUSF - PCODES) Use the EMPLOYEE table (ee# and company) to map to HREMPUSF then map to PCODES using Field key to type and A N or D field to Code. PCODES is only needed if you want to print the description for one of the values in a user field.

In your select or somewhere else in Crystal you will need something like {HREMPUSF.FIELD_KEY} = "91" to identify which user field you are after. Each User field on the HR11 will have it's own unique key.

We have found that it is easier to build a sql view or stored procedure of the user field info and run Crystal against that info. Depending on how you want to view the UF info, you may have problems getting all your data formatted writing Crystal directly against the UF.

I thought of a perfect solution... Pivot selection...

I had a View created that makes each userfield name into a field so that there is a view called UserFields that has the COMPANY, EMPLOYEE, USER1, USER2, USER3...... Of course the names of the fields are the names from the HRUSERFLDS table...

Shane