Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Sorting Expert Post Reply Post New Topic
Author Message
CrystalGirl
Newbie
Newbie


Joined: 22 Feb 2015
Online Status: Offline
Posts: 36
Quote CrystalGirl Replybullet Topic: Sorting Expert
    Posted: 19 Apr 2016 at 4:02am
Hi all,

I am trying to do sort on my below dataset from a field called "SchoolEmployees"

SchoolEmployees

Records1
Records2
Records3
...
...
...
DummyAdmin1
DummyAdmin2
...
...


So what I am trying to do is to have the value of DummyAdmin1 and DummyAdmin2 list at the very end of the records. Records1, Record2 and so on could be varies. The datatype if varchar and contains all of the school employee names but I want those two values (DummyAdmin1 and DummyAdmin2)always stay at the end of the result set (as the last two records). How can I achieve this sorting?

This result set is what I want to have:

SchoolEmployees

Records1
Records2
Records3
...
...
...
...
...
DummyAdmin1
DummyAdmin2

Thanks guys

Edited by CrystalGirl - 19 Apr 2016 at 4:05am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 19 Apr 2016 at 4:34am
One way (not real clean) is to create a formula and add like a XXX to the dummy names (i.e., if {Name} like 'Dummy' then 'xxx'+{Name} else {Name}.  And sort by the formula.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.032 seconds.