crystal reports

Accepted answer

if(({?FieldName})='')then 'Null' else {?FieldName}

right click on field>>>Format object>>common tab >>last(display string)(formula)

divya14y ago

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

Sudhakar Chaudhary14y ago

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.

divya14y ago

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

divya14y ago

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

Vilas Gite14y ago

hi divya
plz provide exact code snippet
Thanks