Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 540
	Members: 0
	Total: 540

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

Crystal links between ICTRANS and ITEMMAST

1 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

nwhitacre

New Member

Posts: 4

11/13/2013 4:28 PM

ICTRANS has all the data I need but the DESCRIPTION from the ITEMMAST. Every time I try to link in Crystal, I lose my data from the ICTRANS. Can anyone tell me what I need to link in order to make this work? Thanks

John Henley

Posts: 3353

11/13/2013 6:23 PM

What field(s) are you using for the join? Ideally, you need to join thru ICCOMPANY to get the item group in addition to joining from ICTRANS to ITEMMAST on the ITEM field.
I'm guessing you only have one item group, and you are joining directly from ICTRANS to ITEMMAST on just ITEM.
If that's the case, make sure it's a left outer join.