How to sum field show 0.00 format in crystal report if field IS NULL

Question

1.00/5 (1 vote)

See more:

I WANT TO Sum a field i crystal report if field IS NULL then sum field is show 0.00 format

What I have tried:

I WANT TO Sum a field i crystal report if field IS NULL then sum field is show 0.00 format

Posted 26-Jun-16 21:43pm

Member 12556431

Updated 26-Jun-16 22:28pm

Add a Solution

Comments

Maciej Los 27-Jun-16 3:46am

"I want to..." is not a question at all!

1 solution

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)

JayantaChatterjee · Accepted Answer · 2016-06-26T22:28:00

Solution 1

You can try this Links:-
To add the custom function to a Crystal report[^]
Creating Your Own Custom Functions - Crystal Reports 10: The Complete Reference[^]

In Crystal Report there is IsNull() function to check the value is null or not, this links are for IsNull function:-
IBM Knowledge Center[^]
Crystal Reports Custom IsNull Function - Stack Overflow[^]

I hope this links will help you..

Posted 26-Jun-16 22:28pm

JayantaChatterjee

Comments

Member 12556431 27-Jun-16 5:56am

Help me for this Sum a field in crystal report if field IS NULL then sum field is show 0.00 format

JayantaChatterjee 27-Jun-16 6:23am

right now I'm not having the Crystal report..
the code will be like this:-
if IsNull({reportFieldName}) then
0
else
{reportFieldName}

after this code added to function, you have to add this function to the report, then add a summery fields and select this function Name with sum function in the report..

Member 12556431 27-Jun-16 6:34am

sir thanks but it is not work

JayantaChatterjee 28-Jun-16 0:58am

what have you tried ??
did you create the function with the above code, and then drag and drop the function into your crystal report from the "Field Explorer"?

Member 12556431 28-Jun-16 3:10am

Thank you Jayanta Chatterjee Sir it is work for me, lots of thanks to you sir.

JayantaChatterjee 28-Jun-16 5:53am

you're welcome...
Please accept the the Solution..

Member 12556431 28-Jun-16 8:40am

Sir can you help me for convert number to words in indian rupees in Rupee and Paise like 1110.56 c#
in word like, One Thousand One Hundred Ten Rupees And Fifty Six Paise.

JayantaChatterjee 30-Jun-16 0:54am

You need to post that in a separate question, because it will help others to find there problems Solution...

Member 12556431 28-Jun-16 8:47am

im making a code but if i inter dot then program is stop working and error