Click here to Skip to main content
11,640,866 members (60,020 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: VB.NET
Hi All,

I have a integer column in Database.
i am substracting that column in crystal reports formula fileds.
It throws an error as "Division by Zero".

But in that column their is no zero values.

Please anybody suggest me.

Thanks in advance
Posted 8-Nov-12 1:43am
ryanb31 at 8-Nov-12 7:57am
Somewhere it is doing a divide by zero. It may be in the SQL and not in your formula.
Ahmedwaheed at 8-Nov-12 16:43pm
you may have null columns or you have formula depend on anothe formula which get Zero

please get your sql result and formulas

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Mika Wendelius 380
1 OriginalGriff 205
2 DamithSL 203
3 Afzaal Ahmad Zeeshan 129
4 CPallini 125
0 Mika Wendelius 370
1 OriginalGriff 205
2 CPallini 125
3 DamithSL 105
4 Afzaal Ahmad Zeeshan 70

Advertise | Privacy | Mobile
Web01 | 2.8.150731.1 | Last Updated 8 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100