This is a report I use (the SQL from Crystal)
I was able to grab this by doing a trace on my user and running the Roles report from the Resource entry screen.
SELECT
humres."usr_id", humres."fullname",
pwrole."role_name"
FROM
{ oj ("pwruc" pwruc INNER JOIN "pwrole" pwrole ON...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.