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.
Thanks.