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.
Don’t let what you cannot do interfere with what you can do. — John Wooden
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2011 Barry Ralston
About this chapter
Cite this chapter
Ralston, B. (2011). PowerPivot and SQL Server Reporting Services. In: PowerPivot for Business Intelligence Using Excel and SharePoint. Apress. https://doi.org/10.1007/978-1-4302-3381-7_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3381-7_9
Publisher Name: Apress
Print ISBN: 978-1-4302-3380-0
Online ISBN: 978-1-4302-3381-7
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)