How do I use an unfiltered view in a SSRS report

• Question

• 

  

  0

  Sign in to vote

  I am trying to write a report that shows what privileges users have on the system. I need to do this so the administrator can see what privileges a user has in regards to the license they need. This is to ensure compliance with the new Microsoft Licensing model.

  To produce the report I need I need to join on the following tables: RolePrivilegesBase and PrivilegeBase

  CRM does not let you include non filtered views in a query so does anyone know of any way of doing this?

  We host CRM for quite a number of customers and we want to be able to deploy this report to all of them.

  Wednesday, February 7, 2018 10:17 AM