--- a/fhiiqm/report/keytyp_bestand_all_report.php	Wed Aug 06 09:42:40 2014 +0200
+++ b/fhiiqm/report/keytyp_bestand_all_report.php	Fri Feb 05 14:03:40 2016 +0100
@@ -205,7 +205,7 @@
         }
          
         $sql = "SELECT h.keytyp_ID, key_level,  
-                    CONCAT (nachname, ', ',vorname, ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE (CASE aktiv WHEN -1 THEN 'Gast' ELSE 'inaktiv' END) END, ')') AS keyowner, IFNULL(abt_name,'') AS abt, h.depot_ID, 'ma' AS tab,  
+                    CONCAT (nachname, IFNULL(CONCAT(', ',vorname),''), ', ' , IFNULL(abt_name,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE (CASE aktiv WHEN -1 THEN 'Gast' ELSE 'inaktiv' END) END, ')') AS keyowner, IFNULL(abt_name,'') AS abt, h.depot_ID, 'ma' AS tab,  
                 	SUM(CASE WHEN pers_action='get' THEN IFNULL(pers_anz,0) ELSE 0 END) - SUM(CASE WHEN pers_action='out' THEN IFNULL(pers_anz,0) ELSE 0 END) - SUM(CASE WHEN pers_action='lost' THEN IFNULL(pers_anz,0) ELSE 0 END) AS bestand,m.persknr
                 	FROM fhiiqm.Mitarbeiter m 
                 	INNER JOIN Keytyp_MA h ON m.persknr=h.persknr