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
Conquer Microsoft(R) SQL Server(R) 2012 Reporting Services - from the inside out! You're beyond the basics, so dive right in and really put this report generation application to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts prepare and deliver a variety of interactive and printed reports using SQL Server 2012 - and challenge yourself to new levels of mastery. Install and configure SQL Server Reporting Services Put Report Builder and Report Designer tools to work Create interactive, online reports that enable users to sort and filter data Add charts and gauges to present data visually Deploy reports to Microsoft SharePoint(R) Server Monitor server performance and help secure content Use subscriptions to distribute reports via email Build ad hoc reports and extend them with custom code