Date values for null are coming as 01 Jan 001 in crosstab

MKI

In my crosstab cell when ever i do not have value for date values(I am using postgres DB) in Database i am getting the values as 01 Jan 001. I want the cells to be blank when there is no value in DB

I need help please

kclark

Select the cell in your crosstab, go to visibility, check hide element, in the expression builder you can say something like<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
data["DATE"]==null
</pre>
<br />
And it will hide everything that doesn't have a date, you can also do the same thing if you were trying to hide specific dates.