Thursday, April 24, 2014

Reports with SharePoint List as data source

[Draft}

One easy way to generate dynamic reports/metrics based on SharePoint List as data source is using SharePoint Designer and various List Views.

Other easiest way is using SSRS services on SharePoint and Report Builder 3.0 as report development tool.

To create reports using Report Builder 3.0 go through the link:

1. Install SQL Server Reporting Services with SharePoint Integration Mode and attach to the SharePoint Form. or install SSRS with SharePoint Integration Mode on any of the existing SharePoint Server.

2. Enable Reporting Services on SharePoint Form in Central Administration and make sure it is running and you can see SSRS related section on Central Administration.

3. Enable the below highlighted features and PerfornamcePoint Services to use PerformancePoint Dashboards/ScoreCards/KPI etc.




4. Create a document library and enable Content Types and add Reporting services related content types as described in this link.

Create A SharePoint Document Library To Store SSRS Reports



No comments:

Post a Comment