Solved: group by a field and sort by another one in a across tab report in Crystal Report 2013

Create Account

Crystal Reports

Questions

Followers

Top Experts

Jerry Seinfield🇺🇸

group by a field and sort by another one in a across tab report in Crystal Report 2013

Hi there,

I created a report with an across tab group by 2 fields (state and type), beautiful.

Now, I have to sort that report by Amount field.

Basically, in the first group State field, I need to sorted by 3rd field, called Amount, and then have 2nd group field (this have an specific order, I'm fine with this), in a across tab report in Crystal Report 2013.

This 3rd field is a dynamic amount. So, how can I sort descended, my 1st group by amount field? I tried several ways with no luck.

Thanks for help in advance,

J

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Serena Hsi🇺🇸

A walk-through on grouping and sorting in Crystal Reports:
http://www.bitool.net/tutorials/crystal-reports/sorting-grouping.html

Mike McCracken

You can only sort the groups by the field itself or a summary based on the grouping

Create a summary on the amount field in the group footer
You can then sort the group through the
REPORT --> GROUP SORT menu

mlmcc

Jerry Seinfield🇺🇸

ASKER

Thanks, mlmcc I'll try it.

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Jerry Seinfield🇺🇸

ASKER

Hi there,

It didn't work.

Well, your suggestion will work for a detailed report, but I'm working with a Cross Tab report, when I go to Cross-Tab tab -> Group Options -> I got "State", which the group, and I can only sort: ascending, descending and specific order, any of this options work for me.
Because field1 is a state, and the cross tab report have to order by Amount.
My second level of grouping ("City" field) has an specific order, I think that may cause the problem.

       Florida                    Texas                    Arizona
     Miami      Orlando      Total      Houston      Austin      Total      Phoenix      Tucson      Total
Amount      250       250      500        150        150      300        50        50      100
Qty        5      1      6        8      1      9        15        1        16

Now, my report is been sort: Arizona,Florida,Texas (alphabetical ascending), this is not what I want.

I need it to sort by Total Amount, so it has to be Florida,Texas and then Arizona. And this total amounts are going to change daily, so the sort will automatically.

Thanks for any help.

Mike McCracken

I just played with a cross tab using you r data.

If you change the cross tab so the State and City are the rows then you can sort rows based but a summary value.
You right click the state in the (preview only)

Click ROW OPTIONS --> ROW GROUP SORT EXPERT

mlmcc
Report2.rpt
SalesTest.xls

Jerry Seinfield🇺🇸

ASKER

Interesting,...

I got your point, but my report is by columns instead of rows. So, by columns I just got Column Options -> ascending, descending and specific order only :-(

Thanks for help

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Jerry Seinfield🇺🇸

ASKER

I managed to go to Group Sort Expert, I choose "State" tab, then "For this group sort" -> All and Base on Sum of Amount field, and I checked "descending", and believed or not, my report is still sorted alphabetically.

I don't not what else to do. It should work...but it doesn't.

Thanks guys for help.

Jerry Seinfield🇺🇸

ASKER

Well, it works but is messing my second group with "specific order"...

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

Crystal Reports

Questions

Followers

Top Experts

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.