Need to sort on a calculated field in a sub report
Posted on 2010-08-29
Hello, I am trying and have been searching and trying for a very long time. I am using Crystal Reports XI , the database is Oracle. I am unable to sort a field on my subreport. The field is a calculated field. The calculated field is really a Running Total which is in the footer of the report. the tricky thing about this running total is that it calculates the average. Tricky? because I used a hint I saw elsewhere to calculate the average to omit the zeros. This works well and gives me the correct average. the average does not relate to test scores. I have tried the group sort by option and the running total formula dies not appear in the list. I have read a little about the 'whileprinting records" option, but I do not have a clue how to use it, or if it will help. I would like the report to sort names based on the the average; highest score to lowest score. At the moment, the data looks like the following (all is written in the Group Foote1; detail section is suppressed): Thank you in advance.