PRS Technologies Home Page
 Home   Associates   References   Downloads   Elite   Links   Contact Us 

Elite Custom Report Security

Question: How do you set up security to control access to custom reports in Elite ?

If you want user access to look at the field win_cust . gen05, then in you have to put something like urept5>97 into that field.

So for example, if you do not want users who have uaccess.urept5 < 98 to be able to run a particular custom report, you would update win_cust as follows:

update win_cust set gen05="urept5>97" where reportid="[my report id]" and rectype="1"

So if a user with uaccess.urept5 of 97 of less tries to the run that report, Elite will not let them into the report. Other custom reports run just fine.




 Home   Associates   References   Downloads   Elite   Links   Contact Us