• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

ACTRANSREL.mx_value_3

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
mdevecchis
New Member Send Private Message
Posts: 0
New Member
12/19/2006 6:56 PM
I am using crystal reports to create a work order report. We currently use the field mx_value_3 in the ACTRANSREL table to distinguish between travel and labor. I lose this field when the work orders move to the ACTRANS and GLTRANS tables. Does anyone know how I might link the mx_value_3 field into my report, from what table it might be held in?
John Henley
Send Private Message
Posts: 3355
12/20/2006 11:32 PM
ACMXVAL -- link to it via OBJ-ID and make sure you use a LEFT OUTER JOIN (or a subreport). If you link from ACTRANS to ACMXVAL in the report itself, and since a transaction may have multiple attributes (or none), you'll need to take that into account in your record selection in Crystal. In other word, your selection criteria would need to include something like:
(IsNull({ACMXVAL.OBJ_ID}) OR ({ACMXVAL.MATRIX_CAT}="BLAHBLAH")).
Thanks for using the LawsonGuru.com forums!
John
mdevecchis
New Member Send Private Message
Posts: 0
New Member
1/19/2007 12:51 PM
Thank you John, I was finally able to get my report to show travel and labor. You were a big help?