why is SUM option missing in Summarized Fields?

[#1]

The SUM option is not visible in the Summarised field of Crosstab Expert.I did not face this problems in other reports. I could still use MAX but then the TOTAL also becomes a MAX value and not actual sum

Secondly, why is there a space between the columns(red X mark)?

[ido_millet · Accepted solution]

1. Data type is not numeric

2. CrossTab spans more than one page.

[Former Member · Accepted solution]

k it is in fact a numeric data type. In my database marks is stored as decimal number. i am using vb.net where i set the marks datatype as 'decimal' in the dataset. By the way in my previous reports, the SUM option was available.

[former_member292966 · Accepted solution]

Right-click the Marks field in the field explorer and select Browse Data. What type does Crystal think that field is?

[Former Member · Accepted solution]

its working now. i really dont have any idea how. i just createsd anew report. thanks anyway. BTW, in browse data, the type is NUMBER now. Thanks