Home ▶ Reports

Help with Reporting

Show null value in report

Ezra Posts: 99 9/26/2022	Ezra Posts: 99 Hi, I have a report and has a column of date completed. However, even if the value of date is still null, there is a default value showing in the report. How can I make it so that the report will show null value instead of the default date? am trying to check the properties but there is no option for allow null value. Regards, Ezra
	0 link
osman.zama@decisions.com Administrator Posts: 36 9/26/2022	osman.zama@decisions.com Administrator Posts: 36 Hello, This is expected behavior that happens when a null value is passed in the date and time field. This can be avoided by setting the Data and time fields to take Null values from the data structure. You can achieve this by checking the "Allow null value" box under Data Member Information when editing the Data structure This will result in an empty field being displayed in the report if no value is present. Additionally, you can configure the report to display a predefined text Example "Null" for fields with no value. This can be done by checking the "Override display of null values " property under the reports Settings Settings and then entering a text under Display Value For Null I have attached screenshots for your reference as well. Regards Osman Zama "", "" Attachments: Reports setting 2.png Data structure settings 1.png
	+1 link
Ezra Posts: 99 9/27/2022	Ezra Posts: 99 Hi Osman, Thanks for the assistance! Regards, Ezra
	0 link