Who's On?

	Membership:
	Latest: Emily
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5308

	People Online:
	Visitors: 127
	Members: 0
	Total: 127

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3290
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244

ACTRANSREL.mx_value_3

2 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

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: 3359

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?