0

Crystal Report field question

I am attempting to write a report that will show the information that is contained in the log notes on a work order. Has anyone tried this? What table is this information stored in?

1 comment

Date Votes
0
Avatar
Josh Cole

Ben,

Work Orders are called Callsheets in the database. All Log Notes are stored in the CallSheetLog table. You can access the log notes for a given work order by matching the nCallSheetUID field from the original work order to the field with the same name in CallSheetLog.

I hope this helps!

Josh Cole - Software Engineer

Please sign in to leave a comment.