Sage Construction & Real Estate

Welcome to the Sage Construction and Real Estate products Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

PJ Field Reports Labor Table Fields using ODBC

Posted By Steve B over 4 years ago

I'm trying to pull records from the PJ Field Reports Labor Table in Crystal but I'm unable to figure out how the employee is being linked. Does anyone know what table is being used to link the employee to the PJ Field Reports Labor table?

Top Replies

Bill Kormoski over 4 years ago in reply to Steve B +2

What are you wanting to do?

0 Bill Kormoski over 4 years ago

Steve,

Do you mean the PJ Field Labor report or Payroll Time report?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Steve B over 4 years ago

The PJF_FIELDREPORTS__LABOR table.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Bill Kormoski over 4 years ago in reply to Steve B

What are you wanting to do?
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Steve B over 4 years ago

That is exactly what I needed. This is a complicated link just to get to the employee name but it works.

Thank you Bill.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Steve B over 4 years ago

I'm creating a custom form in Crystal that pulls LABOR, MATERIALS, EQUIPMENT, and JOURNAL ENTRIES from a daily report for displaying in a Work Order ticket.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage Construction & Real Estate

PJ Field Reports Labor Table Fields using ODBC

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING