I'm not new to Crystal, but I have just recently returned to it after a number of years and having to relearn it on my own has fried my brain. Thanks to Brian and all else who manage and use this forum....it's a huge help.
I'm putting summary information in a report footer and am struggling with my last two summaries. I need to display the content of a name field where the content of a number field is the maximum in the result set. I'm working off a SQL view I wrote specifically for this report.
The logic is like this: where {table.field} is the maximum in the result set, print {table.field} in the footer.
I'm sure this is a really stupid question....
Thanks!
IP Logged
