Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.
Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.
Course Of The Month
5 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
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.
Person1 4.813
Person2 5.000
Person3 4.769
Person4 5.000
etc....
Person1 4.813
Person2 5.000
Person3 4.769
Person4 5.000
etc....
[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
You cannot sort on a running total. Your only hope is using an Oracle view that does the calculations before it gets to Crystal.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
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?
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Suggested Courses
Course of the Month5 days, 22 hours left to enroll
707 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.