![report builder sharepoint report builder sharepoint](https://i.stack.imgur.com/Opw1C.png)
Once the replication is created, SQList replication service will start off for synchronizing the SharePoint lists and SQL database.
![report builder sharepoint report builder sharepoint](http://www.technicaloverload.com/wp-content/uploads/2014/09/4-query-designer.png)
Last step is to give this replication a name, and keep the default options as checked and then click finish.Next, enter the details for the destination SQL database connection which is the database we created earlier.Next step is to select the replication lists, we will select the 3 lists which are going to be used for this exercise i.e.and select the SharePoint site which contains the lists and clicks next.Create a new SharePoint connection, enter the connection name and Table prefix.Open SQList Manager and click on “Create a new replication”.Secondly, we need to replicate the data from SharePoint lists into SQL Server database. Step-2: Replicate and Synchronize data to Database Open SQL Server Management Studio and create a new database named “ProductsReportdemo”.It is a custom list which contains data of all the product category groups.įirst off, we need a database that will be used for replicating the data coming from SharePoint lists.Category group ID (lookup column linked to Category groups list).It is a custom list which contains data of all the product categories.
![report builder sharepoint report builder sharepoint](https://www.mssqltips.com/tipimages2/5958_ssrs-sharepoint-lists-join.009.png)
Category ID (lookup column linked to category list).This list contains all the products data.If you would rather watch a video, this tutorial is also available on our YouTube channel at: SharePoint Listsįor this demo, we will use three custom lists with some data in SharePoint.
#Report builder sharepoint how to
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.Ĭreate a column chart in SSRS Report Builder which shows the total price and total current stock of products by Category Group. 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.