Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Filtered Views in CRM Reporting

Post Author: Joe D365 |

While working with CRM Reports, we faced a scenario where data was not getting retrieved from FilteredViews in our IDE. Interestingly same queries were returning data from CRM tables but nothing from FilteredViews.

E.g. "Select * from SalesOrderDetail" table retrieved rows
"Select * from FilteredSalesOrderDetail" retrieved no rows

We made several checks including:

  • Report connection/data sources
  • User rights in CRM
  • Using the right DB and Organization

These checks yielded no luck. Eventually we found the actual cause.

Filtered views will never return records from a connection string using SQL authentication

Authentication

Use Windows authentication in connection string properties for all CRM reports.

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

Leave a Reply

Your email address will not be published. Required fields are marked *

2 comments on “Filtered Views in CRM Reporting”

  1. This is clear. The FilteredViews of Microsoft CRM are including the platform business logic of CRM. so it includes the security model, too.
    MS CRM can only authenticate users with Active Directory, so if you use SQL Authentication the view has no relation to this user. So no data are found.

  2. I logged in SQL and used authentication as windows credential only. then also i see no data. Can you help me out,

PowerObjects Recommends