Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

printing null values instead of zeroes

Status
Not open for further replies.

gvg356

Programmer
Mar 22, 2012
17
US
I have a report output like
days Jan Feb Mar.....
1 3 2
2 2
3
....
31 0
If there is no value in database it should print null but the issue is for the month of feb we don't have 31 but in my report it is printing 0 instead of null values similarly for april also it is printing 0 in 31 row instead of null.. Is there any way that I can do this in crystal report.
Thanks
 
One of the options is a check box for 'convert NULL values to Default'.

For a numerical field the default is 0, so be sure that option is unchecked ( not sure which menu item it is under, but it is there - under report options, I think)



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top