Crystal Formula - Maximum of a Running Total/Count?
Home > IT Answers > Development > Crystal Formula - Maximum of a Running Total/...
Paullyie
10 pts.
0
Q:
Crystal Formula - Maximum of a Running Total/Count?
Crystal Count, COUNT, Crystal Reports
Hi Everyone,

I have a Crystal Report with the usual group headers/footers & detail section.

On my detail section I have a 'running total' it is a count function and it counts the number of lines based on a Unique Reference Number

But my problem is that I want to get the Maximum of this count.
So, if my detail section has a count of 1,2,3,4,5,6,7 detail lines
I want my maximum to return the result 7

The issue with Crystal is that you cannot run a Maximum formula on a count formula
I have converted my count to a string and a number, and still unable to get this result.

Would anyone have any ideas?

Thanks in advanve
Paullyie
ASKED: Jul 22 2009  10:19 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Jade1977
365 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
If I am following what you want to do, you'll need to create a running total just like the one in the detail section, change it to read Maximum, and place it in a group or page footer.
Last Answered: Aug 13 2009  4:47 PM GMT by Jade1977   365 pts.
Latest Contributors: ITKE   10345 pts., M13art   50 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0