How to make inactive users visible to user in report

[Prachi Tikhe]

User can only see active users, inactive users are not visible. 

[Yousaf]

Hi Prachi,

On the sys_user table you can select active is true/false like you need to make report on active/inactive users.

Or refer to this link
How to show only active users on reports


Mark Correct or Helpful if it helps.

[Mark Manders]

Check the query BR's on your user table. It could very well be that inactive users are limited to be seen by admins (or any other specific role(s)).

If my answer helped you in any way, please then mark it as helpful. If it resolved the issue, please mark it as correct.

Mark

[RaghavSh · Accepted solution]

This is either done by:

1. Before query business rule on sys_user table which restricts the non admins to view inactive users.

2. Table level acl in sys_user table which may restrict non admins to view inactive users.

3. If this is specifically in reports, then check report view acl on sys_user table.

Please check both these configsa and change them accordingly.