HELP!!! ANYONE KNOWS HOW TO INSERT 0 TO A BLANK FIELD? 1

[sommererdbeere]

Hi,

please HELP!!!!!!!!!! does any of you know how i can add 0 into a Blank field?

thank u

 

[PAULCALLAGHAN]

Can you be a little more specific. Also, what version of crystal do you have.

 

[tdong]

in the formular fields choose new enter a name then choose use editor. enter the if statement for whatever field you need to replace with 0 when null. I am using CR9 but the idea is the same use if statement

if isnull({table.id}) then 0

 

[tdong]

use the else part if it is not null then the value unchange

if isnull({table.id}) then 0 else ({table.id})

 

[tdong]

then go back to design view and click on the + of formula field and click and drag the new formula you just created to where ever you want good luck. I just had this CR 9.0 for two days getting a hang of it now.

 

[sommererdbeere]

hi, i'm using CR 8.5

thanks for your reply, tdong

i use the isnull to check if it is a null field. in crystal dictionary, it said null doesn't equal to zero or blank. if isnull apply and it said true, it means the field is a null otherwise it's not.

for my case, my field is not a null field. it is a blank field.

please please HELP if anyone knows it.. thank u thank u thank u

m

 

[campsys]

Try:


if ({table.id}) = "" then "0" else ({table.id})

 

[lbass]

Or, you could try:

if trim({table.field}) = "" then 0 else {table.field}

-LB

 

[synapsevampire]

In case you haven't been forewarned, Crystal has dropped the SQL Designer from it's product line in CR 10, so anything you design using it will have to be redesigned (not just repointed) when you upgrade, so try to avoid using it.

As for your formula, I tend to be thorough just in case:

if isnull({table.field}
or
trim({table.field}) = "" then
0
else
{table.field}

-k

 

[synapsevampire]

thorough, but not always accurate (forgot the paren):

if isnull({table.field})
or
trim({table.field}) = "" then
0
else
{table.field}

-k

 

[tdong]

synapsevampire solution would work very well in your case. Your question wasn't clear at start I thought your database allow null then isnull alone would do the trick. hehhehe

 

[sommererdbeere]

hi everyone,

i've tried it, but it doesn't work. is it because i use subreport, that's why it doesn't work?