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