How to sort crystal report by calculated group percentage
Posted on 2008-10-15
I am new to Crystal Reports 11 and would like to sort a report by a calculated value within each group. Specifically, I have a report of Tests (detail) grouped by Student. Each test has an nPassed field (0 = failed, 1 = passed). I would like to calculate the percentage of tests passed for each student, then sort the report by that value (while retaining the grouping by Student). The result would look like:
Student: Smith, John 90% passed
Student: Bishop, Billy 85% passed
Each student might have a different number of tests. I hope to add some drilldown and charting later, once I've got the sort correct so that the top students are at the top of the report.