Link to home
Start Free TrialLog in
Avatar of tomasdlv
tomasdlvFlag for United States of America

asked on

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
Avatar of Mike McCracken
Mike McCracken

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
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.
Avatar of tomasdlv

ASKER

guys what if my REPORT --> GROUP SORT EXPERT is greyed out?
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...
so i've right clicked on the crosstab itself and this is what i get (see Attached)
cross-tab.bmp
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
thanks H0P5....

mlmcc...any ideas?
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
does this mean i have to change my crosstab format
You shouldn't.

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

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

mlmcc
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
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
sorry...here you go
Copy-of-comm2.txt
See if this one works.

mlmcc
comm2.txt
i still dont see it sorted...i tried to see if the group sort is available but its still greyed out
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
ok i'll try that but i wont be next a pc until tomorrow...i hope this is ok
No problem.

mlmcc
it does not work on the footer.
is there a way we can put a formula in there?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok thx