I need to create a report from an external SQL database and run the report at SharePoint 2016. The SQL database size was big around 5 GB, How can I do it?
I think to create a procedure at SQL database level to read external bulk data and then create the report at SharePoint. There are only Library Report, Are there any solution to generate and run a report at SharePoint ??
Looks like you need SSRS.
First step would be to install and configure SSRS on the SQL Server if it's not done yet. Then, you need to create a new SSRS report. When you are done with your report, you can either post a hyperlink to it in SharePoint, or, if you are using the SSRS in the SharePoint Mode, you can show reports right inside the SharePoint site.
If you don't want to deal with the SSRS in the SharePoint mode, you can simply display the SSRS reports as iFrames inside SharePoint.
