Book description
Use your SQL Server skills to create and manage key data reports
Deliver interactive business intelligence reports using SQL Server 2012 Reporting Services, and help facilitate real-time decision making throughout the enterprise. SQL Server expert Stacia Misner shows you in detail how to design, manage, and access custom reports that capture data from multiple sources. This book is ideal for experienced SQL Server developers, whether you’re new to Reporting Services or upgrading from an earlier version.
Discover how to:
Use the latest features, including the Power View ad hoc reporting tool
Design reports by understanding how your audience accesses and uses data
Add interactive features to help end users sort and filter data
Create rich data visualization with charts, gauges, indictors, and data maps
Configure your report server, provide security, and monitor report contents
Use SharePoint or Report Manager to search and access reports online
Create a library of report parts that clients can use for ad hoc reporting
Build and manage reports using Reporting Services as a development platform
Table of contents
- Microsoft SQL Server 2012 Reporting Services
- Dedication
- Introduction
-
I. Getting started with Reporting Services
- 1. What’s new in Microsoft SQL Server 2012 Reporting Services
- 2. Introducing the Reporting Services environment
- 3. Understanding deployment scenarios
-
4. Installing Reporting Services
- Reviewing hardware and software requirements
- Planning accounts for reporting services
- Performing the installation
- Configuring native-mode Reporting Services
- Configuring partial integration with SharePoint
- Configuring SharePoint for local mode reporting
- Configuring SharePoint integrated mode
- Installing Report Builder
- Installing sample databases
-
5. Exploring Reporting Services fundamentals
- Understanding design environments
-
Developing a report with Report Builder
- Launching Report Builder
- Getting Started Wizard
- Using the dataset designer
- Getting familiar with the Report Builder interface
- Adding a data source
- Adding a dataset
- Adding a report title
- Using data region wizards
- Adding a data region manually
- Adding fields to a table
- Adding a total
- Grouping data
- Inserting page breaks
- Formatting a report
- Previewing a report
- Saving a report
- Managing a report
- Viewing a report
-
II. Developing reports
- 6. Planning your report design
- 7. Working with report server projects
-
8. Retrieving data for a report
- Understanding data source types
- Connecting to data with data sources
- Retrieving data with datasets
- 9. Designing the report layout
- 10. Working with the tablix
- 11. Developing expressions
-
12. Using functions
- Getting help for functions
- Using text functions
- Using date and time functions
- Using math functions
- Using inspection functions
- Using program flow functions
- Using aggregate functions
- Using financial functions
- Using conversion functions
- Using miscellaneous functions
- Working with hierarchical data
- 13. Adding interactivity
- 14. Creating dynamic reports with parameters
- 15. Managing the page layout
- 16. Using Analysis Services as a data source
-
III. Adding data visualizations
- 17. Creating charts
- 18. Working with chart elements
- 19. Comparing values to goals with gauges
- 20. Displaying performance with indicators
- 21. Mapping data
- 22. Working with map elements
-
IV. Managing the report server
- 23. Deploying reports to a server
- 24. Securing report server content
- 25. Performing administrative tasks
-
V. Viewing reports
- 26. Accessing reports online
- 27. Working with subscriptions
- 28. Data alerting
-
VI. Ad hoc reporting
- 29. Reusing report parts
- 30. Preparing to use Power View
- 31. Using Power View
-
VII. Using Reporting Services as a development platform
- 32. Understanding Report Definition Language
- 33. Programming report design components
- 34. Programming report server management
- 35. Programming report access
- A. About the authors
- Index
- About the Author
- Copyright
Product information
- Title: Microsoft SQL Server 2012 Reporting Services
- Author(s):
- Release date: April 2013
- Publisher(s): Microsoft Press
- ISBN: 9780735670051
You might also like
book
Pro SQL Server 2012 Reporting Services, Third Edition
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your …
book
Professional Microsoft SQL Server 2012 Integration Services
An in-depth look at the radical changes to the newest release of SISS Microsoft SQL Server …
book
Beginning SQL Server Reporting Services
Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports …
book
Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
Book-and-video package gets novices up to speed on Microsoft SQL Server 2012 If you need a …