crystal reports

Question

hai guys In crystal reports i want to display Null in place of empty fieldcan any one help me...

Sudhakar Chaudhary · Answer

if(({?FieldName})='')then 'Null' else {?FieldName} right click on field>>>Format object>>common tab >>last(display string)(formula)

divya · Answer

Thank u very Much It is very Useful to Me......

Sudhakar Chaudhary · Answer

you can also make a formula and replace it on the place of your field. if any problem then explain by which procedure you are making report.

divya · Answer

Thank you Sudhakar but error is like The Field name is not known .Already i have taken the values from view.

divya · Answer

Here below iam giving sample screen shot ...i want to display null or 0 where ever data is not there in data baseex Ballon Selling CostBaloon Purchase Cost etc...

Vilas Gite · Answer

hi divya plz provide exact code snippet Thanks