Index: branches/5.2.x/core/units/spam_reports/spam_reports_config.php
===================================================================
diff -u -N -r15165 -r15563
--- branches/5.2.x/core/units/spam_reports/spam_reports_config.php	(.../spam_reports_config.php)	(revision 15165)
+++ branches/5.2.x/core/units/spam_reports/spam_reports_config.php	(.../spam_reports_config.php)	(revision 15563)
@@ -64,7 +64,7 @@
 	'CalculatedFields' => Array (
 		'' => Array (
 			'ItemName' => 'IF(%1$s.ItemPrefix LIKE "%rev", review.ReviewText, "")',
-			'ReportedBy' => 'reported_by.Username',
+			'ReportedBy' => 'IF(reported_by.Username = "", reported_by.Email, reported_by.Username)',
 		),
 	),
 
@@ -86,7 +86,7 @@
 		'ReportedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
 		'ReportedById' => Array (
 			'type' => 'int',
-			'formatter' => 'kLEFTFormatter', 'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s  FROM ' . TABLE_PREFIX . 'Users WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Username', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'sample_value' => 'Guest',
+			'formatter' => 'kLEFTFormatter', 'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s  FROM ' . TABLE_PREFIX . 'Users WHERE %s', 'left_key_field' => 'PortalUserId', 'left_title_field' => USER_TITLE_FIELD, 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'sample_value' => 'Guest',
 			'default' => NULL
 		)
 	),