On-premises · SharePoint Server
Reflex Reporting
Reflex Reporting makes it easy to produce multi-site reports from content in your SharePoint lists, by mirroring list items into a SQL table in real time.
What it does
Tables that match your lists
A reporting database whose fields use the names your users see.
Without touching the content database
Querying SharePoint’s content database directly can void Microsoft support and lock tables. Reflex Reporting avoids that.
Multi-site reports
Report across sites, with proper sorting and grouping.