This might help. I prefer to create views and use crystal to format the data. Here is the view I created to pull our rights. select M.RULEID , U.CONSUMERID AS USERORROLE , M.RULENAME , M.RULEOWNER , M.STARTDATE --datetime field for CR , M.ENDDATE --datetime field for CR , D.STRUCTUREID, S.STRUCTURENAME , D.ELEMENTID, E.ELEMENTNAME , D.ELEMENTORDER , V.SEQUENCEID , D.OPERAND , V.ELEMENTVALUE1 , D.ELEMENTVALUE2 , V.RULEGROUPING FROM ERS_RULEMASTER M JOIN ERS_RULEMAPPINGS U ON M.RULEID = U.RULEID JOIN ERS_RULEDETAIL D ON M.RULEID = D.RULEID JOIN ERS_RULEVALUES V ON D.RULEID = V.RULEID and D.STRUCTUREID = V.STRUCTUREID and D.ELEMENTID = V.ELEMENTID JOIN ERS_STRUCTURE S ON D.STRUCTUREID = S.STRUCTUREID AND S.STATUS = 'A' JOIN ERS_ELEMENTS E ON D.ELEMENTID = E.ELEMENTID where M.STATUS = 'A' --active records Joan
|