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

Crystal Reports 11 cross-tab sort

Hi,

How can I sort a field in ascending order except one particular value in a cross-tab report.
In my attachment, the emp column has distinct values. I want the coulmn in ascending order but the emp "DEVON" must be displayed at the last.
I dont want to use the sort "in a specified order" because I have hundreds of emps.
Any thoughts?

Thanks

CROSS-TAB-SORT.xls
0
D-pk
Asked:
D-pk
  • 2
  • 2
1 Solution
 
JayConverseCommented:
Make a formula that prepends a "ZZZ" to only employee code DEVON, then sort on that, but display the original code.
0
 
D-pkAuthor Commented:
I am kinda new to crystal, can you explain further?
0
 
JayConverseCommented:
Do you know how to make formulas?

if {EMPCODE} = "DEVON" then "ZZZ"+"DEVON" else {EMPCODE}

and use that in your cross tab.  Press the Options button on the Cross-Tab group, and use {EMPCODE} as the Group Name field.
0
 
D-pkAuthor Commented:
Perfect.. Thanks JayConverse
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now