Solved

Need to sort on a calculated field in a sub report

Posted on 2010-08-29
4
594 Views
Last Modified: 2012-06-27
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....  
0
Comment
Question by:mtrout
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
JayConverse earned 500 total points
ID: 33556852
You cannot sort on a running total.  Your only hope is using an Oracle view that does the calculations before it gets to Crystal.
0
 

Author Comment

by:mtrout
ID: 33558743
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.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33563382
If you right click the field, you can use INSERT --> SUMMARY

mlmcc
0
 

Author Closing Comment

by:mtrout
ID: 33567136
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.
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question