• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

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
0
tomasdlv
Asked:
tomasdlv
  • 12
  • 9
  • 3
1 Solution
 
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
0
 
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.
0
 
tomasdlvAuthor Commented:
guys what if my REPORT --> GROUP SORT EXPERT is greyed out?
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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...
0
 
tomasdlvAuthor Commented:
so i've right clicked on the crosstab itself and this is what i get (see Attached)
cross-tab.bmp
0
 
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
0
 
tomasdlvAuthor Commented:
thanks H0P5....

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

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

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

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

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

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

mlmcc
0
 
tomasdlvAuthor Commented:
ok thx
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 12
  • 9
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now