Users in the group are not able to view reports

[Naga jyothi sri]

Hi, 

For a requirement, we have created a custom table for service requests, created a custom portal to raise service requests for custom categories that are stored in custom table created. Also, created a support team with 9 users in that group who will work for requests raised from custom portal. we created a scoped application and a role for that application and also, a custom role for the portal, assigned those roles to users. Added report_user role to the users to view the reports and dashboard that has data of custom service requests table. Here the issue I'm facing is after adding mentioned custom roles and report_user role to the user, when i impersonate and check for reports, it is not showing reports for that user. It is showing like mentioned in attached image. What i have to do to fix this.

Thank you!

[Rajesh Mushke]

Hi @Naga jyothi sri,

Have you created any report_view ACL already? check the below example and try it based on that. 

There are two kinds of report_view access control lists: report_view table ACLs and report_view field ACLs. Report_view table ACLs prevent users from viewing report content based on the table specified in the ACL. Report_view field ACLs prevent users from viewing reports that use the field specified in the ACL in the group by, row, column or aggregation.

For example, a report_view field ACL grants the report_admin role viewing access to the salary field in an HR table. When users with the itil or report_user role access a report grouped on the salary field, they see: Access to this content denied based on report_view field ACLs.

Note:

The report_view table and report_view field ACLs do not support scripts or advanced conditions.