Link to home
Start Free TrialLog in
Avatar of mtrout
mtroutFlag for United States of America

asked on

Need to sort on a calculated field in a sub report

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.

Person1           4.813
Person2           5.000
Person3           4.769
Person4           5.000

etc....  
ASKER CERTIFIED SOLUTION
Avatar of JayConverse
JayConverse
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mtrout

ASKER

Hello There JayConverse, any ideas as to how I could change the field to a summary ( I guess) so that I may see it in the Group Sort Expert when I select ALL based on and then see the summary?   But, it may be the same answer as you stated above, but I thought that I would ask.  Thank you.
Avatar of Mike McCracken
Mike McCracken

If you right click the field, you can use INSERT --> SUMMARY

mlmcc
Avatar of mtrout

ASKER

What I need to do (and based on special given requirements), Crystal Reports being the High level application that it is, cannot do what I need.  A special View would need to be created as I saw a  hint elsewhere on the web.