nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Default date is set to 01/01/1

Radu Maftei

Hello,
 
I have a problem with an BIRT Report on version 4.6.
 
 
I have some columns which have dates. On preview the dates are showing and where there exists no date the field is empty.
 
When i run the report instead on an empty field (at those specific columns), it displays 01/01/1.
 
So I tried to map the cells in my CROSSTAB to display empty field where 01/01/1 exists (with match).
 
That works, but there is a problem, every date that starts with 01/01/x (Eg: 01/01/2015) is also recognized as an 01/01/1 so it emptys the field for those values too(which exists in the database fields on the preview).
 
Has anyone encountered this.
 
Thank you.
 
Note: I cannot convert those columns to String, because I have to export them to xls after, so that the filter of excel should recognize those columns as type Date.

Find more posts tagged with

Comments

Clement Wong

There are a few options, you can do either:
 
1. Filter the null values at the data set level. Either use a filter, or change your query that excludes those null values.
 
2. Add a Filter on the Crosstab report item. The Target would be your Date field, the expression would be:
data["theDateColumn"] Greater Than BirtDateTime.date(1,1,1)

Radu Maftei

Hi Clement,
 
Thank for you response.
 
In some strange way, the empty fields were not recognized as NULL in the crosstab. So what I did it was to map the field to empty where date is lower than 01/01/1970. It worked like this.
 
Thanks again.