SQL Server Reporting Services (SSRS)

7 Reasons why SQL Server tables are a better option for reporting then SharePoint Lists

28/02/2021/in Export SharePoint to SQL Server, Power BI, Replicate SharePoint to SQL Server, Reporting, SAP Crystal Reports, SharePoint BI, SQL Server Reporting Services (SSRS) /by Danish Detho

SharePoint Lists plays a pivotal role in any SharePoint development primarily because it is the preferred source of data storage in SharePoint. All the great features like security permissions trimming, views, various types of columns, data validations, and entry forms that come out of the box and can be easily configured give SharePoint Lists an edge over any other data storage options. However, there are several scenarios that make SharePoint Lists less desirable especially when it comes to reporting. Reporting becomes very critical when we store business-critical data in SharePoint since it is vital for business users to make decisions. E.g. if you are storing customer orders in SharePoint Lists then soon you will need to develop some reports to get insights on your customer buying trends.

Generate SSRS Charts and Reports from live SharePoint list data

06/01/2020/in Export SharePoint to SQL Server, Reporting, SharePoint BI, SQL Server Reporting Services (SSRS), Uncategorized /by Danish Detho

In this blog, I will show you the best way of creating a chart in SSRS Report Builder on live data coming from SharePoint lists. We will start off by looking at the lists which we are going to use for this demo and followed by how we can use SQList to synchronize data between SharePoint Lists and SQL Server database and to finish things off, we will look at how to generate our reports and charts much faster.

The best way to access SharePoint data from Power BI, SSRS, and other BI tools

04/11/2019/in Power BI, Reporting, SharePoint BI, SharePoint Reporting, SQL Server Reporting Services (SSRS) /by Francesco

Watch our presentation, where we are going to show you the best way to access live SharePoint data from any reporting and BI tool, like Power BI, SSRS, or Crystal Reports.

Comparison of BI Tools: Power BI vs Cognos vs Crystal Reports vs SSRS

16/12/2018/in Export SharePoint to SQL Server, Power BI, Reporting, SAP Crystal Reports, SharePoint BI, SharePoint Reporting, SQL Server Reporting Services (SSRS) /by Francesco

Which is the best Business Intelligence (BI) tool available? Why is it the best and what distinguishable features makes it the best one? What are the alternatives? What is the current client base of this tool? Is this BI tool the right one for your business as well? What should you be looking for when evaluating BI tools? Will your business analyst or end users be capable enough to extract desired information from this tool?

In this blog, we evaluated some of the most popular BI tools out there, provided an overview and compared features, hopefully helping you to make the right choice of BI tool to meet your business requirements. A first step to finding the best tool for your company.