• Registered: 2020-10-26
  • Posts: 25

Topic: help Null Field

is there any way that if i save a field blank
in report preview in blank field show writer "null"????

field data type is integer and it's show 0 if  Field is empty

like

https://i.ibb.co/4FkgS9w/1.png

and i want like this

https://i.ibb.co/n3vdjvD/2.jpg

  • Registered: 2021-01-02
  • Posts: 23

Re: help Null Field

What database are you using and how are the fields configured?

3 Reply by bbrother (edited by bbrother 2021-03-05 02:32:08)

  • Registered: 2020-10-26
  • Posts: 25

Re: help Null Field

iwkom wrote:

What database are you using and how are the fields configured?

thanks for you attention and project is attached.
this is for "data" table and "data" form

Post's attachments

Attachment icon Project.7z 277.97 kb, 550 downloads since 2021-03-05 

  • Registered: 2019-12-24
  • Posts: 169

Re: help Null Field

Hello bbrother,
.
I used an OnBeforePrint event on the MasterData1 of the report that checks the values of your fields. Then replaced the text to null if they were 0 as in your example.
.
See the screenshot.

Post's attachments

Attachment icon 7410_Project.zip 335.24 kb, 334 downloads since 2021-09-02 

"Energy and persistence conquer all things."