Cross-Tab assistance Needed 1

[jdemmi]

I am pretty knowledgable when it comes to Crystal but I am a cross-tab rookie at best. Yesterday I created a cross tab report which works fine and pulls exactly what I need. However, there is a "sorting" issue I would like some help with.

My columns contain text fields which contain 1 of the following values "None", "Very High", "High", "Medium" and "Low". Currently they are arraned in alphabetical order from left to right. Like this.

"High" -- "Low" -- "Medium" -- "None" -- "Very High"

Is there any way to change this? I would like to be able to arrange them like this.

"Very High" -- "High" -- "Medium" -- "Low" -- "None"

In a similar report (not cross tab) I was able to create a formula which set Very High = 1, High = 2, Medium = 3 and Low and None = 4.

This allowed me to sort them based on the number so I could arrange/sort them in this order

VERY HIGH
HIGH
MEDIUM
LOW
NONE

Thanks in advance.

(PS I am also going to post this in the CR other topics forum)

-- Jason
"It's Just Ones and Zeros

 

[TheBlondOne]

Have you tried specifying the grouping order, this is under group options and then specified order. You can then set the order to what ever you want it to be.

 

[jdemmi]

Well I hadn't until you asked me if I had

But the problem is that there is no group and if I go to the group expert then it creates a new group (and I can specify the order as you suggest) but the group is inserted BELOW the cross tab report.

The cross tab report (created with the wizard) is all placed in the report header.

PS -- I am using CR 10

-- Jason
"It's Just Ones and Zeros

 

[TheBlondOne]

If you right click on the cross-tab and go to cross-tab expert. Then select the field which you want to order (this will be either in the row or column box on the right hand side), then once that is selected if you then click on group options, then from the drop down box (where is says in ascending order) select specified order, you will see another tab called specified order. If you click on that tab you will see another drop down box, in this box will be the values from this field. You then just select the values from the list in the order that you want, this will force the cross-tab to display them in that order.

HTH

 

[jdemmi]

Oh crap....I feel like a big dummy.

Thanks for the help. Here's a star for you.

-- Jason
"It's Just Ones and Zeros