Maximum of a Summary

[slicknick515]

I wrote a utilization report. It is the total amount of a product used in a given time period. I want to show which product was used the most. To get the total used, I simply did a summary that is the sum of @totalused.
I can't figure out how to make it look at total used and bring back the product name value of the total used. By the way, it is grouped by product name.

Any Ideas?

 

[Madawc]

Try Insert > Crosstab, that could show totals by product

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[slicknick515]

Well, the report is written and I have to show all the products usage but I wanted to put a little "fun fact" in the group header that shows the most used product and how much was used of that product.

 

[lbass]

You could insert a crosstab and then select the crosstab object->report->group sort->topN: 1.

This is actually the simplest solution, if you need the result in a header section. There is another approach using SQL expressions that you could potentially use, depending upon your version, the complexity of your selection formula and table structure.

The very simplest solution would be if you could use the result in a footer section.

-LB