Crystal report : how to display some user define string for decimal data field if it is null?

Question

0.00/5 (No votes)

See more:

Hello everyone...

I have sql server table like

ID   R1       R2
--------------------
1  1100.50   550.30
2  NULL      980.20
1  1200.75   620.00
2  NULL     1030.31

I want to display some user defined string in crystal report if value for R1 or R2 column is NULL.
for example: for ID 2 R1 = NULL
so, I want to display "NA" or "Not in use"

What I have tried:

I tried following formula in Format Object --> display string option of R1 report field

if isnull({PP_credit_sale.R1}) then
    "NA"
else
    Cstr({PP_credit_sale.R1})

But it displays Blank Field.

Can anybody help me on this? How can I achieve this? is it possible for decimal field?

Posted 23-Jan-17 21:33pm

pratt1332

Updated 26-Jan-17 21:22pm

Add a Solution

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)

mahendra pal25 · Answer 1 · 2017-01-26T21:22:00

Solution 1

try this might work
if Cstr({PP_credit_sale.R1})="NULL" then
"NA"
else
Cstr({PP_credit_sale.R1})

Posted 26-Jan-17 21:22pm

mahendra pal25

Updated 26-Jan-17 21:23pm

v2