Change of order 1

[gav12345]

Hi,

Using CR10 / CE10 with an Oracle 9i stored procedure.

I have a report that uses a crosstab. The crosstab has 2 column headings, 'timepointunit', which is just a text field, and 'timepoint', which is a numeric field. In the Crystal report, the columns look like:

Day
-14 -7 0 7 14 21 28 35 42 49 56

Unfortunately when I save to Enterprise the order of the columns changes to:

Day
0 14 -14 21 28 35 42 49 56 7 -7

Does anyone have any idea why Crystal Enterprise would change the order of crosstab column headers / how to get round this?

Thanks for any suggestions.

Gavin

 

[synapsevampire]

It would appear that the latter is seeing the data as strings instead of numerics.

Make sure that the field is clearly identified as a numeric, if need be create a formula of:

val({table.field})

to use as your cross-tab column.

-k

 

[gav12345]

Thanks k, that was it. The field was numeric but I used

tonumber({table.field})

which fixed it. Odd that CE treated it like a string in the first place.

Gavin