Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Chart Legend 2
- Thread starter clapag22
- Start date
-
1
- #2
clapag22: Have a look at either Specified Order for the On Change of field or use the TopN expert to achieve a different sequence to both your axis and your legend David C. Monks
david.monks@chase-international.com
Accredited Seagate Enterprise Partner
david.monks@chase-international.com
Accredited Seagate Enterprise Partner
I have a similar problem. I tried the solution given in the response with no success.
Does it make a diffence if the line chart is part of a sub-report (which is my case)?
Also, my chart has 2 "on change of" fields and my "Show value" is a formula.
Could this have an effect as well?
Does it make a diffence if the line chart is part of a sub-report (which is my case)?
Also, my chart has 2 "on change of" fields and my "Show value" is a formula.
Could this have an effect as well?
-
1
- #4
What version of CR?
Is the a group/chart or an Advanced/Detail chart? Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
Is the a group/chart or an Advanced/Detail chart? Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
I should probably clarify the problem a little more:
The 1st "on change of" field appears on the horizontal axis in ascending order.
The 2nd "on change of" field appears in the legend BUT NOT IN ASCENDING ORDER. It appears as if the order is random.
The graph itself is OK, but I always want the values to appear in ascending order in the legend.
I even tried adding groups to the sub-report to force-order them, but to no luck.
Currently, the chart is in the Report Header. I also tried to put it in the Rpt Footer thinking that it might make a difference.
It appears that the order is based on the order that it first appears on the chart. In my case, the first horizontal "bucket" on the graph is missing one of the points. It doesn't show up until the 3rd "bucket". This point shows up as last on the legend.
The 1st "on change of" field appears on the horizontal axis in ascending order.
The 2nd "on change of" field appears in the legend BUT NOT IN ASCENDING ORDER. It appears as if the order is random.
The graph itself is OK, but I always want the values to appear in ascending order in the legend.
I even tried adding groups to the sub-report to force-order them, but to no luck.
Currently, the chart is in the Report Header. I also tried to put it in the Rpt Footer thinking that it might make a difference.
It appears that the order is based on the order that it first appears on the chart. In my case, the first horizontal "bucket" on the graph is missing one of the points. It doesn't show up until the 3rd "bucket". This point shows up as last on the legend.
You are exactly correct. The order that second group values appear are the order that the legend uses. Unfortunately, the specified order feature in the "on change of" property will only effect the Groups that appear within the first group. I don't know of a way around it. Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question