Grouping by a reference field in a report or list view on a database view shows (empty) for all groups - Known Error

Grouping by a reference field in a report or list view on a database view shows (empty) for all groups Description When creating a report on a database view, grouping by any reference field shows (empty) for all groups on the report. This occurs regardless of the joins on the database view (occurs even when there are no joins) and regardless of the table(s) in the view.

Steps to Reproduce

Steps to reproduce ( Report ):

Create a new database view. Add the [task] table to the database view (Where clause is not necessary). Create a new report and select this database view as the table. Choose the Bar report type. Group by 'Assigned to' (or any reference field) Run the rerport. Notice that all groups show (empty) even though the aggregated totals are correct Steps to reproduce ( List View ):

Complete steps 1 to 2 from above. Open the list view for the database view. Personalize the list to show 'Assigned to' (or any reference field). Right click the column header for Assigned to and select Group By Assigned to. Notice that all groups show (empty) even though the aggregated totals are correct. Workaround As a workaround, change the prefixes used in the database view to be lowercase.

After carefully considering the severity and frequency of this problem, and risk of attempting a fix, it has been decided to not address this issue in any current or future releases. We do not make these decisions lightly, and we apologize for any inconvenience. If you have any questions regarding this problem, contact ServiceNow Technical Support .