As many of you already know, in order to figure out which workbooks had succeeded or failed execute in their data refresh, you need only to go the PowerPivot Management Dashboard (Central Administration > General Application Settings > PowerPivot Management Dashboard) in order to see the status of your data refresh as noted in the figure below. Figure 1: PowerPivot Management Dashboard: Data Refresh Web Parts But how about if you wanted to create a SSRS report of the same (or even more) information so that way you can create alerts and/or have an atom feed of this information? …
Reporting Services, Report Builder, and ReportViewer Controls
I had been asked a number of times what is the difference between Reporting Services, Report Builder, and ReportViewer Controls, so here’s a quick recap: Reporting Services: This is the server-based reporting platform as part of the Microsoft BI stack that allows you to create reporting solutions against multiple data sources. More information can be found at: http://msdn.microsoft.com/en-us/library/ms159106.aspx. As part of the Visual Studio 2008 Business Intelligence Development Studio, you can create your reports in a development shell which ultimately creates Repot Definition Language (RDL). Report Builder 2008: Report Builder is an Office-like tool that allows you to create reports with all…
Presentation: SQL Server Reporting Services: IT Best Practices
This is Lukasz Pawlowski and my presentation at the Microsoft Business Intelligence Conference 2008 (October 2008) on SQL Server Reporting Services: IT Best Practices.
Presentation: Building and Deploying Large Scale SSRS using Lessons Learned from Customer Deployments
This is Lukasz Pawlowski and my 2007 SQL PASS Summit presentation on building and deploying large scale SSRS using lessons learned from customer deployments.