XI Cross Tab Specific Order

[Lhuffst]

I've created a cross tab that uses a formula for the column headers. When I had to edit the formula, it didn't update the formula automatically so I removed the column and added it back in. Now it doesn't want to let me do a specific order. Any ideas?

My formula is:
@RefDecode
if {Command.REFID} = 1 then 'Feasibility Reviews'
else if {Command.REFID} = 2 then 'HPA'
else if {Command.REFID} = 3 then 'Database Search'
else if {Command.REFID} = 4 then 'Letter of Findings'
else if {Command.REFID} = 5 then 'PIA Letters'
else if {Command.REFID} = 6 then 'Plan Distributions'
else 'Check'

The changes that I made was shorting the literals such as Letter of Findings went to LOF.
I tried to refresh and while that runs the report again, it didn't update the formula in the crosstab column.
Thanks
lhuffst

 

[lbass]

Please explain whether you used your formula as the column field or whether you used it as a customized column name.

-LB

 

[Lhuffst]

Hi. It's the column field. When you click on it the group option button becomes active. When I changed the literals in the formula, I was in the field explorer window. Thinking that I should have done it in the cross tab (under cross tab expert) boxes, I tried that as well but still do not see any values popping up when I select "in specified order".
lhuffst

 

[lbass]

Did you reenter the specified order values after changing the column field (which is essentially what you did)?

Also note that you can't use specified order if you are using a group sort.

-LB

 

[Lhuffst]

When I changed the values, I realized that the specified order disappeared and tried to re-enter the info but in the drop down boxes, the values were missing. What I just finished doing was create the report as a new report with the new updated values and it seems to work. I wonder if I'm doing something in the wrong sequence or if this is a bug? Thanks for all your help.