ACTRANSREL.mx_value_3 - LawsonGuru.com - LawsonGuru.com Forums -

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

mdevecchis

New Member

Posts: 0

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

Posts: 3366

New Poster

Engaged Reader

Avid Reader

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")).

mdevecchis

New Member

Posts: 0

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?