Advertisement

PowerPivot and SQL Server Reporting Services

  • Barry Ralston

Abstract

SQL Server Reporting Services is a set of features included with Microsoft’s SQL Server product for the creation, management, and execution of predefined reports. PowerPivot for Excel and SharePoint can use SSRS reports as a data source for solutions developed in either mode of PowerPivot. Reversing the roles of PowerPivot and SQL Server Reporting Services is also possible—that is, SQL Server Reporting Services can utilize PowerPivot for SharePoint databases as a data source for SSRS reports. In this chapter, we will examine the case for using SQL Server Reporting Services and PowerPivot together in order to deliver analytics and predefined reporting from a common dataset.

Keywords

Business Intelligence Business Rule Report Manager Portable Document Format Radio Button 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Barry Ralston 2011

Authors and Affiliations

  • Barry Ralston

There are no affiliations available

Personalised recommendations