Subscribe to SQL Server Reporting Services

Category: SQL Server Reporting Services

Create Master-Detail SSRS report from 2 SharePoint Lists using Report Builder

In this post, I will explain two different approaches to create SSRS report to display data from 2 SharePoint lists. Creating similar report from two tables in SQL database may not be very tricky as one can write a SQL query that fetches relational data from two tables which can be consumed in a single […]

How to Create and apply filter using multi-value parameter in a SSRS report using Report Builder

In this post, I will explain how we can create a multi-value filter and apply it on SharePoint list using Report Builder. Before we start just have a look at the SharePoint list first. This list contains school applications received from different countries for different schools. Our target is to create a report that should […]

How to create and customize Pie Chart using SSRS Report builder in SharePoint

In this post, we will create a Pie Chart that will display report from the SharePoint list. It shows the number of applications received for different schools. Something like this –  Create a ‘Reports’ document library in SharePoint site using ‘Report Library’ List template. Go to “List settings”, click on ‘Add from existing site content […]