How do I use an unfiltered view in a SSRS report RRS feed

  • Question

  • 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