I am looking for some help with grouping in Crystal 10.0. I have a report that list people in multiple records based on the tests they have had done. I only want to see the first test of the month (I found this by choosing the minimum date and placed this in the group)and then group on the value of this test result. I am running into the person showing up in multiple groups. Here is what my output looks like
8.0-8.9
123 Person 1 6/21/2005 8.6
456 Person 2 6/19/2005 8.5
9.0-9.9
789 person 3 06/06/2005 9.1
123 Person 1 6/01/2005 9.5
I really only person 1 to show up in the 9.0-9.9 group since that test result was earlier in the month. Is there a way to only have this person show up once on the report and the on time based on the earliest date of the month?
Thanks so much!!!
8.0-8.9
123 Person 1 6/21/2005 8.6
456 Person 2 6/19/2005 8.5
9.0-9.9
789 person 3 06/06/2005 9.1
123 Person 1 6/01/2005 9.5
I really only person 1 to show up in the 9.0-9.9 group since that test result was earlier in the month. Is there a way to only have this person show up once on the report and the on time based on the earliest date of the month?
Thanks so much!!!