locked
RE: SSRS reports are SQL queries restricted to views and/or filtered views only? RRS feed

  • Question

  • One of the guys decided to add database privileges to the PrivReportingGroup group because the reports were erroring when querying any of the base tables.  It seems to me that I've seen many badly concocted reports that ignore security and nonetheless run successfully.
    Wednesday, August 12, 2015 3:31 PM

Answers

  • Heaven forbid I read the v6_reporting doc, "Filtered views exist for all Microsoft Dynamics CRM entities, including custom entities. Your custom SQL-based reports cannot read data directly from the Microsoft Dynamics CRM database tables. Instead, you must use the filtered views to retrieve data for your custom SQL-based reports."
    • Marked as answer by mardukes Wednesday, August 12, 2015 6:15 PM
    Wednesday, August 12, 2015 6:15 PM