Solved

Special order in crystal

Posted on 2013-02-01
2
374 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

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

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 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