I am very new to Crystal Reports, and find myself stuck on what is probably a really simple problem -- but I need help in order to complete this report.
I need a formula (and help advising on where to put the formula) for the following:
One of my fields, "Case Number", is set up to include many different case numbers, but there are many duplicate numbers as well. The reason for the duplicate case numbers is due to the fact that there could be several different "Events" for the same Case Number.
One of the "Event" numbers will be greater than all the other numbers for the duplicate "Case Numbers", and that is the one I need to include in the report. I would like to be able to suppress all the other "Event" numbers that are lower than my highest number.
I hope I have made this clear -- I am such a newbie.
I thank you in advance for your help. Kathryn.