Create a distribution report then specify custom field widths. When you run the report and drill down you will see that the information listed for each project does not line up as per the specified custom widths.
You can use the following Advanced SQL query in Reports to query for Null values in Sub Relational Fields. @where XXX_PRIMARYTABLENAME.TS_SINGLERELATIONALFIELD in (select TS_ID from XXX_AUXTABLENAME where TS_SUBRELTARGET is null) XXX_PRIMARYTABLENAME = The name of the Primary Table you are reporting on where the Sub Relational Field was added.
