Suppose I have a table with following report.
Now if I login from User A, Department A data should be displayed. Similarly I login from User B, Department B data should be displayed.
What are possible options to do it?
Posted on May 12, 2017 at 9:55am
If you have the commercial version of jrs, and your report uses a Domain, then there's a whole description of how to do it in the secuity guide:
what you can try is to use LoggedInUsername buit-in parameter to retrieve logged in user and use it in a query
to retrieve requried records:
Shouldn't I use roles instead of using username?
it depenends on your requirements. You mentioned users in question:if I login from User A, Department A data should be displayed
You can use any of the built-in parameters per your scenario.