Skip to Content
Former Member
Apr 20, 2010 at 09:12 AM

Division problem


I have a crystal sql command as follows

select uni.uprovince,sum(Tamt_r1 + Tamt_r2 +Tamt_r3 +Tamt_r4 +Tamt_r5) / sum(uheadcount) as averagesales, from uni join guide on uni.uguicode = guide.gcode join travel on uni.utracode = travel.tagent where uni.utracode ='{?tradecode}' and uni.udate between {{?date}} and {{?date2}}

group by uni.uprovince

For the result of averagesales, I can see the value to hundred digit like 234.00 , if the value exceed hundred value like 1345.00,

which means when it exceed hundred value, it shows blank on the crystal report. I am using the sql command in VS 2008.

What's wrong with the field setting or the sql command. I run the sql command in visual foxpro, and it can return normal value.

Why crystal report limit the division result to hundred value.