Skip to Content
author's profile photo Former Member
Former Member

Sorting based on Formula results

I have built a report that is constructed like this

Main Report

Group one = Sales Agents Location

Group two = Sales Agents Names

Group two Footer A

I have subreport linked to the Sales Agents ID that totals their tours taken.

Group two Footer B

I have a subreport that is linked to the Sales Agents ID that totals their Sales Made

I have a formula that divides Tours by Sales to get their ratio.

I need to SORT each agent by highest ratio however my Group Expert is grayed out. Is their another method?

Edited by: Holly Elliott on Sep 19, 2008 9:07 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 07:17 PM

    Because of when Crystal will process the Group Sorting, you can only sort on subtotal summaries that are solely calculated by data in the main report.

    It sounds like your subtotals are dependent on totals from the subreports, which won't be processed until after the Group Expert.

    Take a look at the topic "Multi pass reporting" in the CR Help for more information on this subject.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.