Solved

Special order in crystal

Posted on 2013-02-01
2
373 Views
Last Modified: 2013-02-01
how do i sort like this
before order

AE-9730
AE-9731
AE-9732
AI-9731
AI-9732
AIT-9730
AIT-9731
AIT-9732
AR-9730
AR-9730
after order
AE-9730
AIT-9730
AE-9731
AI-9731
AIT-9731
AE-9732
AI-9732
AIT-9732

I mean the first criteria is before "-"  second criteria after "-"

Is that posible
tsm you guys
0
Comment
Question by:edo60
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 38845569
"I mean the first criteria is before "-"  second criteria after "-" "

That is the opposite of what you have shown.

You create a formula field just used for sorting. It doesn't have to appear in the report.

Split({table,field}, "-") [2] & Split({table,field}, "-") [1]
0
 

Author Comment

by:edo60
ID: 38845605
Some like that, but i need
a
b
c
order too, is that posible?
tsm
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Page Break on Change of Field 2 27
MYSQL responding very slow 3 48
Upgrade code from VS 2010 to VS 2015 7 31
Analyze Shared Variable? 7 27
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question