Group By problem when Field is NULL

[darren.george247]

Hello,

 

A have a Field called TAXID in my iReport. I need to Group all ITEMS by the field TAXID.

 

The report results are fine except when TAXID is NULL. For example certain ITEMS will not have any TAXID associated.

 

Only ITEMS that have a TAXID show on the Report. I need the ITEMS without a TAXID to show up on the Report as well.

 

Is there a way around this? Even if TAXID just shows NULL this would be fine as long as the Items are listed.