Index: trunk/grails-app/services/AssetReportService.groovy
===================================================================
--- trunk/grails-app/services/AssetReportService.groovy	(revision 685)
+++ trunk/grails-app/services/AssetReportService.groovy	(revision 686)
@@ -29,11 +29,19 @@
         // Inner join used to return only attribTypes that are used by AssetExtendedAttributes.
         // So the result is only asset extendedAttributeTypes.
+//         def attribTypesQ = new HqlBuilder().query {
+//             select 'distinct attribT.name'
+//             from 'AssetExtendedAttribute attrib',
+//                     'join attrib.extendedAttributeType as attribT'
+//             order 'by attribT.name asc'
+//         }
+
+        // All active ExtendedAttributes.
         def attribTypesQ = new HqlBuilder().query {
             select 'distinct attribT.name'
-            from 'AssetExtendedAttribute attrib',
-                    'join attrib.extendedAttributeType as attribT'
+            from 'ExtendedAttributeType attribT'
+            where 'attribT.isActive = true'
             order 'by attribT.name asc'
         }
-        result.attribTypes = Asset.executeQuery(attribTypesQ.query, attribTypesQ.namedParams)
+        result.attribTypes = ExtendedAttributeType.executeQuery(attribTypesQ.query, attribTypesQ.namedParams)
 
         // A result is returned for every asset and for any extended attributes.
@@ -65,5 +73,5 @@
                 // Add all attribType columns.
                 result.attribTypes.each { column ->
-                    rows[assetResult.name][column] = '-'
+                    rows[assetResult.name][column] = ' '
                 }
             }
@@ -131,11 +139,19 @@
         // Inner join used to return only attribTypes that are used by AssetSubItemExtendedAttributes.
         // So the result is only assetSubItem extendedAttributeTypes.
+//         def attribTypesQ = new HqlBuilder().query {
+//             select 'distinct attribT.name'
+//             from 'AssetSubItemExtendedAttribute attrib',
+//                     'join attrib.extendedAttributeType as attribT'
+//             order 'by attribT.name asc'
+//         }
+
+        // All active ExtendedAttributes.
         def attribTypesQ = new HqlBuilder().query {
             select 'distinct attribT.name'
-            from 'AssetSubItemExtendedAttribute attrib',
-                    'join attrib.extendedAttributeType as attribT'
+            from 'ExtendedAttributeType attribT'
+            where 'attribT.isActive = true'
             order 'by attribT.name asc'
         }
-        result.attribTypes = Asset.executeQuery(attribTypesQ.query, attribTypesQ.namedParams)
+        result.attribTypes = ExtendedAttributeType.executeQuery(attribTypesQ.query, attribTypesQ.namedParams)
 
         // A useful list of assets without subItems to be given to the user.
@@ -205,5 +221,5 @@
                 // Add all attribType columns.
                 result.attribTypes.each { column ->
-                    rows[rowKey][column] = '-'
+                    rows[rowKey][column] = ' '
                 }
             }