Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 54
	Members: 0
	Total: 54

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

Crystal Report utilizing Account Attribute Lists

2 Replies

0 Subscribed to this topic

24 Subscribed to this forum

Sort:

Author

Messages

JeanneS

Veteran Member

Posts: 49

7/28/2010 1:58 PM

Has anyone created a Crystal Report using Account Attribute Lists? I want to use the GLAMOUNTS table but don't know how to join the account attributes to this table.

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

7/28/2010 3:42 PM

The table you want is GLACCMXVAL. You would need to join from GLAMOUNTS to GLCHARTDTL on CHART_NAME, ACCOUNT, and SUB_ACCOUNT, then from GLCHARTDTL to GLACCMXVAL on OBJ_ID and MATRIX_CAT =

JeanneS

Veteran Member

Posts: 49

7/28/2010 5:59 PM

John - Thank you! It worked great....you saved me so much time.