Sort by font color? 1

[brizaybrizoke]

Is it possible to sort data by it's font color in Crystal Reports 8.5?

For example, if group header font color is red then bring to top.

Thanks

 

[Madawc]

I very much doubt it. You could do the reverse - create a field that is ordered as you wish, say 01 for red, 02 for black, 03 for blue. Use it to conditionally set the font colour, if that option exists in 8.5. Been years since I used it.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[Madawc]

One trick I used from 8.5 onwards was to put a prefix for group header names, to get them in the order I wanted. So if I wanted Oranges, Bananas, Apples in that order, they would be "a) Oranges" etc.

Does that help?

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

You must have used some formula to determine the font color, and it probably was based on ranges that the group summary fell into. If you insert a summary on a detail field at the group level, it activites the group sort feature (report->topN/group sort). Select the summary you want to sort by (that you used to create the font color), and I think you'll see the group values sorted by color.

-LB

 

[brizaybrizoke]

Looks like I got it to work.

I entered a Nth Smallest summary into the Group Footer and then used the TopN/Sort Group Expert.

Thanks!