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

Can't get Group to sort in Crystal 9

Can't get Group to sort in Crystal 9

(OP)
I can't get a Group to sort alphabetically, or by number of records per value. The Group is a formula field. The sort seemed random when the sort was Specific order, which I only did to try to exclude some values. When I set the sort to Descending, only 3 out of 12 values were not in correct descending order, by count.

RE: Can't get Group to sort in Crystal 9

Not going to click on a blind link. Please post the formula for your group.

RE: Can't get Group to sort in Crystal 9

(OP)
Thank you Charliy. There's no Group selection formula, if that's what you meant. (I've never written one). The formula for the field that is used for the group is below (I replaced actual names with "[names]". I would like the detail section to appear either in descending order by the count (much preferred, since the bar graph appearance is in that order), or in alphabetical order.

if {VTMTRACK.ANALYST} in
"[names]"
then {VTMTRACK.ANALYST}

else if {VTMTRACK.DEVELOPER} in
"[names]"
then {VTMTRACK.DEVELOPER}

else if {VTMTRACK.TECH_ANALYST} in
"[names]"
then {VTMTRACK.TECH_ANALYST}

else if {VREQUESTBASE.REQUESTED_BY} in
"[names]"
then {VREQUESTBASE.REQUESTED_BY}

else if {VTMTRACK.REQUESTED_BY} in
"[names]"
then {VTMTRACK.REQUESTED_BY}

RE: Can't get Group to sort in Crystal 9

If you want it sequenced by Count, then what you want is a Top N report.

There is a symbol on the menu bar that looks like a graph with a red up-arrow, that is the Group Sort Expert. Click on that and it will walk you thru creating a Top N sort.

RE: Can't get Group to sort in Crystal 9

(OP)
It didn't seem to work. I found the same item right under Report > Group Sort Expert, where I had been looking!

RE: Can't get Group to sort in Crystal 9

(OP)
Note that the Group Expert seems to require a sort to be selected (ascending, descending, specified order, original order). Wouldn't the Group Sort override that?

RE: Can't get Group to sort in Crystal 9

(OP)
This just in: This time, when I selected ascending order in Group Expert, Group Sort Expert became unavailable (grayed out). At least now I have my second choice working, but there seems to be no way now to enable Group Sort Expert! Strange.

RE: Can't get Group to sort in Crystal 9

I've only done it in CR XI, so I don't know how it may be different in CR 9.

RE: Can't get Group to sort in Crystal 9

(OP)
I created a new summary field, based on the correct formula, removed the former field I had incorrectly selected, and it works now! Case closed. Thanks again.

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