List Available Reports For A User

Hi there,

Don't know if anyone has done this before -and I would really be wondered if not-:
I want to show a list of available reports to a user. Since we are working with SharePoint Portal Server 2003 the webparts can't be used (need MOSS 2007 or WSS 3.0), but I really need to be able to build a dynamically generated list and show it on a sharepoint page.

My first idea is to build a report (kind of menu). I am already this far:

to get a list of reports with the active directory groups and their mapped roles:
select u.UserName, c.Path, r.RoleName

from PolicyUserRole pur

left join Users u on pur.userID=u.userID

left join Roles r on pur.roleID=r.roleID

left join Catalog c on pur.policyID=c.policyID

order by u.UserName, c.Path, r.RoleName


I managed to link active directory via LDAP - linked server.
I even managed to get a list of users and groups. Unfortunately I cannot check whether a user belongs to a group (any idea?), since all of our security (on sql server) is managed by active directory groups this really is a problem.

Or am I completely wrong and is there another way to fetch a list of reports for a user?

Any help would be great!

Thanks,
Tom