Division by Zero error in Crystal Reports

Question

0.00/5 (No votes)

See more:

Hi All,

I am creating one crystal report.
In that report i have used formula fileds.when i place that formula field in report it shows Division by Zero error.

But formula filed having the value.I don't know why it is showing that error.

Please any one advice me

Thanks in advance
Sucharitha

Posted 31-Dec-12 0:48am

RagSuchi

Add a Solution

Comments

ChrisTopherus 31-Dec-12 6:52am

Can you be a bit more precise? Maybe with a little source... The only thing i can say at the moment is: it's not allowed to divide anything by zero.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Aarti Meswania · Answer 1 · 2012-12-31T01:29:00

Solution 3

you can do this also...

VB

{fielda} / iif({fieldb}=0,1,0)

Happy Coding!
:)

Posted 31-Dec-12 1:29am

Aarti Meswania

E.F. Nijboer · Answer 2 · 2012-12-31T01:18:00

Solution 2

Add a simple check for zero to it.
Instead of:

{fielda} / {fieldb}

Check it first:

If {fieldb} = 0 then 0 else {fielda} / {fieldb}

Good luck!

Posted 31-Dec-12 1:18am

E.F. Nijboer

Shubh Agrahari · Answer 3 · 2012-12-31T01:17:00

Solution 1

yes friend you have to check your formula code ...

Posted 31-Dec-12 1:17am

Shubh Agrahari