Report Builder - Not showing Date fields with no data

[Jason McCoy]

I have created a Universal Report in Report Builder. This report was showing all tickets, but last week, two fields that populate Dates have caused the report to not show tickets that don't have data in the date fields. I tried to check the box to 'show items with no data' to allow those fields to populate that have no data, but to no avail. Any help is appreciated!

[Prasanna Ravichandran]

Hi,

This usually happens when the report applies a filter or grouping on those date fields. In many report builders, records with empty dates are excluded when the field is used in criteria, sorting, or aggregations — even if “show items with no data” is selected.

Please check the following:

Remove any filters/conditions referencing those date fields

Verify the fields are not used as required grouping columns

Check for implicit filters like “Date is not empty” or ranges

Ensure the report data source still returns those issues

Refresh/rebuild the report after changes

If the tool supports it, using a formula or default value for blank dates can also help include those records.

Hope this helps 👍