INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Sorting on a summary in a group

Sorting on a summary in a group

(OP)
I have a report for purchases from vendors.

I have it grouped on the vendor and the detail shows all the purchases.

I summed the purchases in the group line so I get the total $ purchased from each vendor.

I would like to sort by this total $ purchased so I get our biggest supplier at the top but can't seem to find a way to accomplish this kind of sort.

Thanks for the help in advance.

RE: Sorting on a summary in a group

I would do it in the data source. Where does the data live? SQL Server?

RE: Sorting on a summary in a group

I believe this can be done with a Group Sort.
Highlight the 'total $ purchased' in your group and then select the "Group Sort Expert" from the toolbar or from the Report menu.
Then change the 'No Sort' to 'All'.

RE: Sorting on a summary in a group

(OP)
Thanks Andy,

Unfortunately the Total $ Purchased is not one of the options when I use the Group Sort Expert.

Laurie,

I am no expert on data bases can you explain further what you mean by "do it in the data source" and "Where does the data live?". Can you explain how I can answer your question?

Thanks again for the help.

RE: Sorting on a summary in a group

Are you pulling the data from Access? From SQL Server?
In Access create a query to pull the data that groups on vendor and sums the total $ purchased. Let us know where the data is pulled from and someone can help you more. I'm taking tomorrow off!

RE: Sorting on a summary in a group

(OP)
We are running Microsoft Dynamics AX and the data is being pulled directly from it.

RE: Sorting on a summary in a group

You can do this by doing a Top N sort on the summary.

RE: Sorting on a summary in a group

As suggested by AndyMc and Charliy, the Group Sort (Top N) is what you need, but it does rely on a Crystal Summary to work, ie, your "... total $ purchased ..." needs to have been created by Insert >> Summary. If your summary is from a Running Total or a variable it won't work.

In the Group Sort Expert you will see a Tab for each group in the report. Make sure the Vendor group is selected if there is more than 1 group, then click on the drop down list and select ALL. You will then be presented with a choice for "based on" from which you need to click on your summary field.

If you require any further assistance, post back.

Hope this helps.

Cheers
Pete

RE: Sorting on a summary in a group

(OP)
Thanks for the explanation. That did the job.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close