Crystal Report Script To Find Title of Max Value?(simple Q!)

Answer 1

I am not sure of all of your requirements, but if you don't mind the Details being sorted the easiest way is to group by the Point column and then if the points are sorted ascending you can simply put the field title and point fields in the Point group footer. This will only display the last row of the Point column which in turn will be the maximum since it is sorted asc.

This will give you the maximum row so if you didn't care to see the other rows you can simply suppress the details section. Hope this makes sense and helps.

Answer 2

You'll need to use a pair of global Crystal variables in a formula that is evaluated in the Details section, as well as two other formulas referring to those variables. The two variables are to store the max of point, and the title associated with that (so presumably a NumberVar and a StringVar, say called MaxPoint and MaxPointTitle). One formula goes in the Report Header, and simply initialises the two variables to zero and empty string. The second goes in the Details section. It evaluates if the current Point value is higher than that stored in the MaxPoint variable. If so, it stores the new value in MaxPoint and the current title in MaxPointTitle. In the Report footer, a third formula is used to display the title and/or value. If you want group max values rather than overall ones, move the formula in the Report header to the Group header, and from the Report footer to the Group footer, and it should work.