Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
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…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
- Document Management
- Document Imaging
- Programming
- Adobe Acrobat
- Scripting Languages
- Printers and Scanners, Images and Photos, Photos / Graphics Software, *Scripts, *PDF
Suggested Courses
Course of the Month7 days, 23 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.