Creating a formula to change the order of the legend?

[robercr12]

HI ,

I am using Crystal v 10.

I have a group called U-height (for servers in a datacenter). In change group options i have done the following:

<5U --> edit -> is less than 5.0
5U-14U --> edit -> is between 5.0 and 14.0
15U-24U --> edit -> is between 15.0 and 24.0
25U-Max --> edit -> is > than or = to 25

The ***--> order of the legend now(from top to bottom)is:

5U-14U
<5U
15U-24U
25U-Max

I want the legend to be(from top to bottom):

<5U
5U-14U
15U-24U
25U-Max

Can you tell me how to achieve this.

I have tried to reorder within the group options but the <5U just will not go to the top of the list in the Legend

Please advise
TIA
bob

 

[lbass]

Have you tried using specified order in the group options?

-LB

 

[robercr12]

Yes. I have tried specified order to begin with and also changed the order multiple times to see if the changes reflect onto the report.

But the <5U is stubborn and just will not go to the top.

I wonder if this has anything to do with < before 5, so i used less than 5U.

I was able to get the following order:

5U-14U
25U-Max
15I-24U
less than 5U

The problem seems to be with 5U-14U. I am not able to move this in the order list no matter what i do.

Please advise
bob

 

[lbass]

I think you aren't using the specified order feature correctly. I just tested this using your original ranges and it worked perfectly to reorder the legend. When you add the formula as the "on change of" group and while it is highlighted, click on "Order"->specified order, and then add the four options one at a time in the order you want, using the dropdown box.

-LB

 

[robercr12]

What i mentioned initially was from:

Report --> group expert --> Group by --> highlight avaiUH then click on options --> in the change group options common tab (specified order). Now in the specified order tab I am doing :
<5U --> edit -> is less than 5.0
5U-14U --> edit -> is between 5.0 and 14.0
15U-24U --> edit -> is between 15.0 and 24.0
25U-Max --> edit -> is > than or = to 25

Alternatively, I cannot customize similarly in the CHART expert as this is a ** drill down chart.
I am using On change of Racktype and availUH ---> show Count of availUH.

I suppose if it were not a drill down i could do what you suggested.

Please advise what i am doing wrong.

Thanks
bob

 

[robercr12]

Without using drill down I tried the *advanced layout option

One change of:
Rack type
Avail UH

show values
Count of avail UH

I highlight avail UH and change the specified order -- the initial problem still persists.

TIA
bob

 

[lbass]

I don't see why you would continue to have that problem in the advanced chart--unless maybe not all UH group members are showing in each of the outer group instances. But you could always change the formula so that the string sorts correctly. If you insert the group on the formula, then even the group chart should sort correctly. In your formula (I'm assuming you created the ranges in a formula), use:

00U-05U
05U-14U
15U-24U
25U+

Strings will sort in order of the values in first position, second position, etc.

-LB

 

[robercr12]

I have done what you suggested from the group Expert -- but the problem persists.

bob

 

[lbass]

Do you have a topN sort in the chart? If not, then please explain the steps you have taken. I have tested this and it works.

-LB