Who's On?

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

	People Online:
	Visitors: 268
	Members: 0
	Total: 268

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

IC DATA in a Crystal Report MAX Function

1 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Jeff N

Advanced Member

Posts: 32

6/20/2019 7:32 PM

I have a Crystal Report that lists monthly usage for the year for inventory tracked locations. The problem I am having is I would like to pull the max usage month into an additional column. My row has the following data in columns; Item#, Description, MO1 Usage, MO2 Usage etc. Does anyone have any insight into any Crystal or SQL Function that will pull the max month data?

Thanks,

Jeff Nelson

Red

Veteran Member

Posts: 87

6/25/2019 2:58 PM

Jeff,
So, I work in CR a fair amount. I just want to be clear on your request. Are you looking for the max amount (usage)? Or are you looking for a flag to indicate which period/month had the most usage (so that your values would be March, April or July)? Also, if you can let me know what your current grouping strategy is (if you are using groups).

I understand your general question, because CR is not great at comparing items outside of a group. One think you may want to consider is the use of arrays. There are three steps in using arrays ( roughly speaking they are defining, populating, and then "printing") and there are some limitations in how large an array can be. Also, as I remember, the same performance impacts of putting summary fields in the header of a grouping, versus the footer of the same grouping, apply to how you might use an array as well.

Something to consider,
Red