Directory and Resource Administrator 6.60
Directory and Resource Administrator 7.0
Directory and Resource Administrator 7.0 SP1
Role and Power Details report does not show nested roles in the Report.
The issue is due to the query for the Role and Power Details Report not including nest rolls.
This is corrected in DRA 7.5 and later. To resolve this issue upgrade to the latest version of DRA.
Below is a workaround that will show the nested roles inside roles. It will show the first level of nested roles in the Role and Power Details report. If a role has a nested role, then the nested role name will show up as "Role: <rolename>" in the Powers column of the report. This gives the same funtionality of what is displayed in the Delegation and Configuration console. To apply this:
1. Open the Directory and Resource Administrator (DRA) Reporting tool.
2. Select File | Enter Design mode.
3. Click on the Query tab.
4. Double-click on the query qryRolesAndPowerDetails.
5. Select View | SQL View.
6. Replace the qryRolesAndPowerDetails query with this one:
SELECT ROLES.McsName, ROLES.McsNameValue, ROLES.McsClass, ROLE_POWER_BINDINGS.POWER_NAME
FROM ROLES INNER JOIN ROLE_POWER_BINDINGS ON ROLES.ROLE_ID = ROLE_POWER_BINDINGS.ID
UNION ALL SELECT ROLES.McsName, ROLES.McsNameValue, ROLES.McsClass, "Role: " & ROLES_1.McsNameValue AS POWER_NAME
FROM (ROLES INNER JOIN ROLE_BINDINGS ON ROLES.ROLE_ID = ROLE_BINDINGS.ID) INNER JOIN ROLES AS ROLES_1 ON ROLE_BINDINGS.ASSOC_ID = ROLES_1.ROLE_ID;