Crystal Report sorting

i have developed a cross tab report in crystal and have come upon something i cant solve. my report (attached) does not sort the totals column descending within each subreport. i have included the report and some images of what i need. thanks
Copy-of-comm2.txt
report.bmp
tomasdlvAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Do you need them sorted by the total column?

I think you have to have a group in the subreport for the row field.
You can then sort the field through the REPORT --> GROUP SORT EXPERT on summary fields.

mlmcc
H0P5Commented:
I was struggling to do this a little while ago alos.

I found you could right click and use group sort expert. For me, from there it would still only let me sort by what I ordered while I set up the cross tab, unless I selected Top N, and made the Top N greater than the total count of groups I had.
tomasdlvAuthor Commented:
guys what if my REPORT --> GROUP SORT EXPERT is greyed out?
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

H0P5Commented:
Sorry, not from the menu's a the top of your screen. Thats greyed out as you don't have any groups on your reports.

Right click on your actual cross tab, and from that menu select from there...
tomasdlvAuthor Commented:
so i've right clicked on the crosstab itself and this is what i get (see Attached)
cross-tab.bmp
H0P5Commented:
Thats a bit random, I checked my cross tab report, which has no other groups, and I can use this area.

I'm using a newer version I note, but it still seems odd.

There is a real expert (mlmcc) posting though. If it can be done another way he will have the solution
tomasdlvAuthor Commented:
thanks H0P5....

mlmcc...any ideas?
mlmccCommented:
You can use the GROUP SORT EXPERT in CR2008.  It is greyed out in CR XI.

As I stated you need a group.

Insert a group on Command.Mon
Insert the Command.Monthly Total in the details section
Right click Command.Monthly Total field
Click INSERT --> SUMMARY
Select it to insert in the group footer

Click REPORT --> GROUP SORT EXPERT
Sort it for ALL

mlmcc
tomasdlvAuthor Commented:
does this mean i have to change my crosstab format
mlmccCommented:
You shouldn't.

Without the data I can't change things and test them.

mlmcc
tomasdlvAuthor Commented:
what do you need? the raw data? i have attached the report on top i can give it to you again
mlmccCommented:
If you attach it with SAVED DATA option then I can see what is going on

mlmcc
tomasdlvAuthor Commented:
this is the data i used to generate the report...please keep in mind that i am dumping this data into sql first and then querying for the report
data.txt
mlmccCommented:
The report has an option to SAVE THE DATA
In the standalone version it is under the FILE MENU

I don't have a database I could put the data into.

mlmcc
tomasdlvAuthor Commented:
sorry...here you go
Copy-of-comm2.txt
mlmccCommented:
See if this one works.

mlmcc
comm2.txt
tomasdlvAuthor Commented:
i still dont see it sorted...i tried to see if the group sort is available but its still greyed out
mlmccCommented:
It was just a thought.  I didn't know if it would work.

Try moving the cross tab to the report footer in the subreport.

mlmcc
tomasdlvAuthor Commented:
ok i'll try that but i wont be next a pc until tomorrow...i hope this is ok
mlmccCommented:
No problem.

mlmcc
tomasdlvAuthor Commented:
it does not work on the footer.
tomasdlvAuthor Commented:
is there a way we can put a formula in there?
mlmccCommented:
It may not be possible then

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tomasdlvAuthor Commented:
ok thx
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.