How can I restrict table visibility for certain users when creating reports?

PerV · ‎05-16-2016

I have a situation where my customer need to create different reports, but having difficulties choosing the correct table to report on. I have created more tables than oob, and the new tables has similar names to the baseline ones. I am looking for a way to somehow only show certain tables for a certain group of users, to make it easier for them to create new reports.

Is this possible? I have considered using a Client script to restrict tables with a certain attribute, but is it possible to use client script on the report form? Can I modify the report form in any way?

//Per

Erik Stolberg · ‎05-18-2016

Easiest way is to create a group, then create an ACL as defined above. Add your group check in the Script field:

if(gs.getUser().isMemberOf('Your Group Here'))

   answer = true;

else

   answer = false;

To easily create for all tables, do an Insert and Stay and just modify the table. It should take you no more than 3 min to setup your group members to report on a few tables.

View solution in original post

PerV · ‎05-19-2016

Erik, that sounds like a great solution. Also solves another situation where I needed to restrict list edit via ACL for users belonging to a certain group. That ended up creating a new role for these users, but this should have been a better solution.

//Per

PerV · ‎05-19-2016

Tested it in my dev instance and it works as expected. Thanks Erik!

//Per