Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Sort order of legend Post Reply Post New Topic
Author Message
ddoubrav
Newbie
Newbie


Joined: 03 Apr 2008
Location: United States
Online Status: Offline
Posts: 3
Quote ddoubrav Replybullet Topic: Sort order of legend
    Posted: 14 Nov 2008 at 2:08am
I have two sub-reports that are pulling from the same database view.  One has no filter on it, the other is a subset of the view looking at only rows where the value is >= 5000.  As far as I can tell, each sub-report creates a line chart with the exact same definitions; however, on one report, the values in the legend are sorted ascending, the other descending.  As a matter of fact, when I bring in the entire dataset rather than just some small amount of test data, it "randomly" sorts my 4 values.  The values in the legend are string[6] - '200505', '200605', '200705', '200805'.
 
What is controlling the legend order? 
 
Thanks for any help!
 
Darin
IP IP Logged
ddoubrav
Newbie
Newbie


Joined: 03 Apr 2008
Location: United States
Online Status: Offline
Posts: 3
Quote ddoubrav Replybullet Posted: 14 Nov 2008 at 6:52am
I have figured out why is does it the way it does, but I want it to STOP!  Based on the filter I put on the value field, it lists the legend fields as the lines start to show up from left to right.  So, if 200705 and 200805 have values that show up immediately, they are listed first.  If it takes two steps to the right before 200505 begins to satisfy the filter then it will show up next and so on.  So, my legend shows 200705, 200805, 200505, 200605.  That's probably not a big deal by itself, however, when the two charts sit next to each other, it is confusing.  I mean, for nearly the exact same chart, one of them has 200705 be the blue line, and the other one has 200705 be the red line.  It's really not acceptable.
 
Thanks again for any help.
 
Darin
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.016 seconds.