• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

Group Sort Expert

I want to sort my report based on a formula that was created from a group total field(s). It is not available in the sort expert. Is there a way?
Basically, I have sales totals grouped by location that are divided by #of sale days. This average column is what I want to sort.
0
kiald
Asked:
kiald
2 Solutions
 
mlmccCommented:
No.  Grouping and sorting are done in the same pass thus the group totals aren't available when Crystal needs them for sorting.

Here is an article that explains the multipass method of producing the report

http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_evaluationtimes.pdf.asp

mlmcc
0
 
MIKESoftware Solutions ConsultantCommented:
Kiald:

I believe that you should be able to create the SUBTOTALS that you are seeking in SQL Server (function or expression) so that Crystal can use the field as a sort field.

The goal being to provide a hard-coded SUBTOTAL field to crystal so that is can sort on it.

Do you have SQL Query Analyzer available to you?

MikeV
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now