Is there a way to build MS Access style reports with SharePoint list data without using Access?

I'm currently able to query a list by making a REST call and dynamicly building an HTML table with the data. With MS Access there is a report builder that connects to a data source and let's you build custom reports. OOTB only lets you create custom views which puts every record on one line. I need to be able to put multiple fields of a record across multiple rows. Any solutions?

1 Answer 1


There's a few OOTB reporting solutions for SharePoint. There are a variety of Web Parts available, current favourite is Power BI https://docs.microsoft.com/en-us/power-bi/service-reports for more conventional reporting SSRS is very much like an Access report. SharePoint reporting can be a complex area and generally requires a reporting server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.