Microsoft SQL Server 2012 Reporting Services [NOOK Book]

Overview

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 ...

See more details below
Microsoft SQL Server 2012 Reporting Services

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$28.49
BN.com price
(Save 43%)$49.99 List Price

Overview

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
Read More Show Less

Product Details

  • ISBN-13: 9780735670075
  • Publisher: Pearson Education
  • Publication date: 4/29/2013
  • Series: Developer Reference
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 1030
  • Sales rank: 645358
  • File size: 32 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server, including Microsoft SQL Server 2008 Reporting Services Step by Step. Stacia is also one of the first to earn the new SQL Server Analysis Services Maestro certification.

Read More Show Less

Table of Contents

;
Introduction;
Who should read this book;
Organization of this book;
Conventions and features in this book;
System requirements;
Code samples;
Acknowledgments;
Errata & book support;
We want to hear from you;
Stay in touch;
Getting started with Reporting Services;
Chapter 1: What’s new in Microsoft SQL Server 2012 Reporting Services;
1.1 Introducing new features;
1.2 Reviewing other changes;
1.3 Parting with Report Builder 1.0;
1.4 Upgrading from prior versions;
Chapter 2: Introducing the Reporting Services environment;
2.1 A reporting platform;
2.2 Reporting life cycle;
2.3 Reporting Services architecture;
Chapter 3: Understanding deployment scenarios;
3.1 Single-server deployment;
3.2 Distributed deployment;
3.3 Scale-out deployment;
3.4 Internet deployment;
Chapter 4: Installing Reporting Services;
4.1 Reviewing hardware and software requirements;
4.2 Planning accounts for reporting services;
4.3 Performing the installation;
4.4 Configuring native-mode Reporting Services;
4.5 Configuring partial integration with SharePoint;
4.6 Configuring SharePoint for local mode reporting;
4.7 Configuring SharePoint integrated mode;
4.8 Installing Report Builder;
4.9 Installing sample databases;
Chapter 5: Exploring Reporting Services fundamentals;
5.1 Understanding design environments;
5.2 Developing a report with Report Builder;
5.3 Managing a report;
5.4 Viewing a report;
Developing reports;
Chapter 6: Planning your report design;
6.1 Knowing your audience;
6.2 Reviewing report options;
6.3 Developing standards;
Chapter 7: Working with report server projects;
7.1 Getting started with report server projects;
7.2 Working with report project files;
7.3 Using report project commands;
7.4 Configuring report project properties;
Chapter 8: Retrieving data for a report;
8.1 Understanding data source types;
8.2 Connecting to data with data sources;
8.3 Retrieving data with datasets;
Chapter 9: Designing the report layout;
9.1 Reviewing report items;
9.2 Adding general report items to a report;
9.3 Working with data regions;
9.4 Using properties to control appearance and behavior;
Chapter 10: Working with the tablix;
10.1 Exploring the tablix;
10.2 Transforming a tablix;
10.3 Configuring tablix properties;
10.4 Working with tablix groups;
Chapter 11: Developing expressions;
11.1 Introducing expressions;
11.2 Using the Expression dialog box;
11.3 Using built-in collections;
11.4 Working with expressions;
Chapter 12: Using functions;
12.1 Getting help for functions;
12.2 Using text functions;
12.3 Using date and time functions;
12.4 Using math functions;
12.5 Using inspection functions;
12.6 Using program flow functions;
12.7 Using aggregate functions;
12.8 Using financial functions;
12.9 Using conversion functions;
12.10 Using miscellaneous functions;
12.11 Working with hierarchical data;
Chapter 13: Adding interactivity;
13.1 Interacting with the report layout;
13.2 Adding navigation features;
Chapter 14: Creating dynamic reports with parameters;
14.1 Working with report parameters;
14.2 Using filters;
14.3 Using parameters with subreports and drillthrough;
14.4 Working with query parameters;
14.5 Cascading parameters;
Chapter 15: Managing the page layout;
15.1 Understanding rendering;
15.2 Adjusting the report size;
15.3 Working with the page header and footer;
15.4 Configuring page breaks;
Chapter 16: Using Analysis Services as a data source;
16.1 Creating an Analysis Services dataset;
16.2 Building a report;
16.3 Designing parameters;
Adding data visualizations;
Chapter 17: Creating charts;
17.1 Adding a chart to a report;
17.2 Using the chart data pane;
17.3 Formatting chart elements;
17.4 Working with data bars;
17.5 Working with sparklines;
Chapter 18: Working with chart elements;
18.1 Changing color palettes;
18.2 Working with vertical axis properties;
18.3 Working with horizontal axis properties;
18.4 Working with series properties;
18.5 Working with pie charts;
Chapter 19: Comparing values to goals with gauges;
19.1 Adding a gauge to a report;
19.2 Working with gauge elements;
19.3 Grouping gauges;
Chapter 20: Displaying performance with indicators;
20.1 Adding an indicator to a report;
20.2 Configuring an indicator;
20.3 Customizing indicators;
Chapter 21: Mapping data;
21.1 Understanding spatial data;
21.2 Using the Map Wizard;
21.3 Finalizing the map;
Chapter 22: Working with map elements;
22.1 Configuring map elements;
22.2 Working with map layers;
22.3 Inserting custom points;
22.4 Understanding order of precedence;
Managing the report server;
Chapter 23: Deploying reports to a server;
23.1 Deploying content;
23.2 Managing content;
23.3 Configuring data source properties;
23.4 Configuring report processing options;
23.5 Working with snapshots;
Chapter 24: Securing report server content;
24.1 Configuring report server security policies;
24.2 Assigning user permissions;
24.3 Configuring item-level security;
24.4 Implementing data security;
Chapter 25: Performing administrative tasks;
25.1 Configuring the report server;
25.2 Managing the report server;
25.3 Monitoring the report server;
Viewing reports;
Chapter 26: Accessing reports online;
26.1 Using Report Manager;
26.2 Accessing reports in SharePoint;
26.3 Exporting reports;
Chapter 27: Working with subscriptions;
27.1 Creating a shared schedule;
27.2 Creating standard subscriptions;
27.3 Creating data-driven subscriptions;
27.4 Managing subscriptions;
Chapter 28: Data alerting;
28.1 Understanding the data alerting architecture;
28.2 Creating data alerts;
28.3 Receiving data alerts;
28.4 Managing alerts;
28.5 Configuring data alerting;
28.6 Monitoring the alerting process;
Ad hoc reporting;
Chapter 29: Reusing report parts;
29.1 Introducing report parts;
29.2 Deploying report parts;
29.3 Using report parts;
29.4 Choosing report parts vs. subreports;
Chapter 30: Preparing to use Power View;
30.1 Using tabular models with Power View;
30.2 Enhancing tabular models for Power View;
Chapter 31: Using Power View;
31.1 Getting started with Power View;
31.2 Visualizing data;
31.3 Filtering data;
31.4 Selecting a display mode;
31.5 Saving a Power View report;
Using Reporting Services as a development platform;
Chapter 32: Understanding Report Definition Language;
32.1 Introducing Report Definition Language;
32.2 Exploring key elements;
32.3 Working with RDL;
Chapter 33: Programming report design components;
33.1 Embedding code in a report;
33.2 Using assemblies to share custom code;
33.3 Creating a custom data processing extension;
Chapter 34: Programming report server management;
34.1 Scripting administrative tasks;
34.2 Working with configuration settings;
34.3 Using the web service;
Chapter 35: Programming report access;
35.1 Linking to reports with URL access;
35.2 Using the ReportViewer control;
35.3 Accessing a report with the web service;
About the authors;
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)