Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Sorting By Conditional Format Post Reply Post New Topic
Author Message
jacobske
Newbie
Newbie
Avatar

Joined: 22 Oct 2009
Location: United States
Online Status: Offline
Posts: 1
Quote jacobske Replybullet 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!
Kelly J.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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...
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.031 seconds.