"# Not Assigned"

Hi,

In our reports, we see # Not Assiged row at the end of each material, sold-to, ship-to etc. for transaction data. There are no attributes, nav. attr. in the report. The values for these Not Assigned rows are 0 but somehow we are not able to remove them from the report. We can always exclude this value in the selection and avoid showing it in the report but do not want to go this path for performace reasons.

Any one has suggestions to overcome this? Please advise.

Thanks,

Praveen