At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
COURSE of the MONTH
9 days, 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
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
- Query Syntax
- SQL
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases, Percona
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Suggested Courses
Course of the Month9 days, left to enroll
764 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.