I put together an internal page on one of my sites where I had to display the users in a DNN Security Role. I used XMP for the task, making the process almost trivial to implement. I thought you might like it, since it shows an example of calling a DNN stored procedure. I've kept it simple - an un-ordered list with no formatting.
<xmod:template>
<listdatasource commandtext="EXEC GetUsersByRolename @PortalId, @Rolename">
<parameter name="PortalId" alias="PortalId" value="8" />
<parameter name="Rolename" alias="Rolename" value="Administrators" />
</listdatasource>
<headertemplate>
<h2>Members</h2>
[ul]
</headertemplate>
<itemtemplate>
[li][[DisplayName]] ([[Username]])[/li]
</itemtemplate>
<footertemplate>
[/ul]
</footertemplate>
</xmod:template>