-> 1 - Roles Query

select RoleID, RoleName 
from Roles

------------------------------------------------------------------------------------

-> 2 - Roles HTML Template (roles.html)

<div>
<a href="/Report?roleid=[RoleID]">[RoleName]</a>
</div>

------------------------------------------------------------------------------------

-> 3 - Users Query

SELECT Users.UserID,
                 Users.Username,
                 Users.DisplayName,
                 Users.Email,
                 CONVERT(VARCHAR(10), UserRoles.EffectiveDate, 7) AS StartDate,
                 CONVERT(VARCHAR(10), UserRoles.ExpiryDate, 7) AS EndDate
FROM Users INNER JOIN UserRoles ON Users.UserID = UserRoles.UserID
WHERE (UserRoles.RoleID = @url_roleid)

------------------------------------------------------------------------------------

-> 4 - Report Style (report.css)


.DNN_Reports_Grid_Header th,
.DNN_Reports_Grid_Row td,  
.DNN_Reports_Grid_AlternatingRow  td{
	text-align: left;
	padding: 5px;
}

.DNN_Reports_Grid_Header {
	font-weight: bold;
}

.DNN_Reports_Grid_Row {
	background-color: white;
}
 
.DNN_Reports_Grid_AlternatingRow {
	background-color: #EBEBEB;
}