Joined: 22 Oct 2009
Location: United States
Online Status: Offline
Posts: 1
Topic: Sorting By Conditional Format Posted: 22 Oct 2009 at 8:39am
Just curious if anyone knows if it is possible to sort by a conditional format in crystal XI.
I created a conditional format to highlight records in various colors (in order for users to see records that may be in error where they have flags set incorrectly). My goal is that once these are highlighted (background color) that I can sort by them, so that users don't have to click through pages & pages to see the records that may have the formatting.
Any help or info is greatly appreciated!
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 22 Oct 2009 at 9:42am
create a formula field using your same conditions for highlighting:
highlight condition True then 0 else 1
Sort primary on this formula field and secondary on any other field you want.
the caveat to this is you cannot do it if any of your conditions for highlighting require a specific sort (e.g. comparing to the previous or next record).
You can also just suppress the other records instead of highlighting and sorting...
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
IP Logged
