Reports restricted based on the user roles

ajunuthula

<p>Hi,</p><p> </p><p>I have a table in the database that holds username , role type and department name, so based on the role type how can I restrict the reports.</p><p> </p><p>For example, user "A" with role 'admin' should see all the reports irrespective of the department.</p><p>user "B" with role 'user ' and department 'dept 1' must see the reports restricted only to that department.</p><p>user "C" with role 'user' but with departments 1 and 2, must be able to see the reports related to those two departments.</p><p> </p><p>Any adivise or suggestion on how to proceed.</p><p> </p><p>Thank you.</p>

black.water

<p>Scripting is your answer!</p><p> </p><p>Use a username parameter and scripting to create a scripted data set of departments to display (be sure elements are distinct). Left outer join it with your database to create a final data set you can display in your report. This should also naturally order your report by department which is always nice</p><p> </p><p>It is difficult to say one surefire method to script the displayed department data set as I'm not sure how your department information is stored in your database (string, array, duplicate usernames with different directories, etc.) Scripting may not be required based on how information is organized, you just need to get that list of departments into a temp data set so you can use it to outer join.</p><p> </p><p>enjoy! </p><p> </p>