Question on organizing/labeling for charts/cross tabs

[FloridaHawk]

I have a formula which is used for grouping, charts and also cross tabs.


numberVar BusSec := {@DateDiff1};

IF
BusSec < 3600 THEN '1- < 1 Hour'
ELSE IF
BusSec >= 3600 and BusSec <=28800 THEN '2- 1 To 8 Hrs'
ELSE IF
BusSec > 28800 and BusSec < 259200 THEN '3- 1 To 2 Days'
ELSE IF
BusSec >= 259200 and BusSec < 604800 THEN '4- 3 To 6 Days'
ELSE IF
BusSec >= 604800 and BusSec < 950400 THEN '5- 7 To 10 Days'
ELSE IF
BusSec >= 950400 and BusSec <=1296000 THEN '6- 11 To 15 Days'
ELSE IF
BusSec > 1296000 THEN '7- > 15 Days'
ELSE
'Other'


The reason I have &quot;1-&quot; is so the report will display &quot;< 1 Hour&quot; first. I would like to be able to display this info without the &quot;1-&quot;. I know I can create a new label formula for group headers but this wont do me any good for the charts and cross tabs. Thanks.

 

[lbass]

In all of these cases, the main report, charts, and crosstabs, you could use &quot;specified order&quot; to get the order you want.

-LB

 

[FloridaHawk]

That works great..but the only thing is the headers dont export to excel when I export a tabular report.