[SalesForce] Custom Report type with User and Case objects

Try creating two custom report types, the first one is Users with Opportunities, the second one is Users with Objectives. Then you should be able to create a join report with the two new report types and join them with the User object.

You can get this information by running queries.

1. Go to workbench.developerforce.com
2. Login using your Salesforce credentials
3. Select the SOQL Query option
4. For Object, choose the CaseShare object.
5. Enter the following query in the "Enter or Modify a SOQL query" field: SELECT CaseAccessLevel,CaseId,Id,IsDeleted,LastModifiedById,LastModifiedDate,RowCause,UserOrGroupId FROM CaseShare WHERE IsDeleted = FALSE 6.Choose the "Bulk CSV" option under the "View As" field. 7.Click on the query button. 8.Download results by clicking on blue arrow. 9.Go back to the SOQL screen and choose User as the object. 10.Enter the following query in the "Enter or Modify an SOQL query" field: SELECT Id,IsActive,Name FROM User WHERE IsActive = True
6. Select Bulk CSV in the View As: field. 12.Click on the query button.
7. Click on the download button with the blue arrow.
8. Now that you have exported both queries out to Excel use VLookup to match the UserOrGroupId column on the CaseShare table with the ID column on the User table and return the Name column value on the User table to the CaseShare table.

This will show every Case the user has access to whether it is because of ownership, Teams, Manual connection, Rule, or being an implicit child. The RowCause field on the CaseShare object notes the reason why the user has access. The values for the RowCause field are Implicit Child, Manual,Owner, Rule, Team. If you have questions on VLookup, leave a comment and I can provide instructions for that. Hopefully this is helpful to you.