Home Page Icon
Home Page
Table of Contents for
Title Page
Close
Title Page
by Grant Paisley, Ken Withee, Thiago Silva, Robert M. Bruckner, Paul Turley
Professional Microsoft SQL Server 2012 Reporting Services
Cover
Title Page
Copyright
Dedication
About the Authors
Credits
Acknowledgments
Foreword
Introduction
Part I: Getting Started
Chapter 1: Introducing Reporting Services
Who Uses Reporting Services?
Dashboards, Reports, and Applications
Enterprise Reporting
Solution Types
Business Intelligence Reporting Solutions
Customizing the Reporting Experience
Summary
Chapter 2: Reporting Services Installation and Architecture
The Basic Installation
The Enterprise Deployment
The Reporting Life Cycle
Reporting Services Tools
Reporting Services Windows Service
Reporting Services Processors and Extensions
Reporting Services Application Databases
Summary
Chapter 3: Configuring SharePoint Integration
The SharePoint Technologies
Installation and Configuration
Architecture
Summary
Part II: Report Design
Chapter 4: Basic Report Design
What Good Are Wizards, Anyway?
Manual Report Design
Summary
Chapter 5: Report Layout and Formatting
Report Layout Types
Designing Multicolumn Reports
Designing Gauge Reports
Summary
Chapter 6: Designing Data Access
Business Intelligence Reporting
Reporting for Relational Data
Filtering Techniques
Using Other Data Sources
Best Practices
Summary
Chapter 7: Advanced Report Design
Headers and Footers
Creating Report Templates
Creating Composite Reports
Designing Subreports
Navigating Reports
Reporting on Recursive Relationships
Summary
Chapter 8: Chart Reports
Chart Types
Creating a Multiseries Chart
Summary
Part III: Business Intelligence Reporting
Chapter 9: BI Semantic Models
Introduction to Data Modeling
The BI Semantic Model
Summary
Chapter 10: Reporting with Analysis Services
Why Use Analysis Services for Reporting?
Using Reporting Services with Analysis Services Data
Working with Multidimensional Expression Language
Adding Nonadditive Measures
MDX Properties and Cube Formatting
Drill-Through Reports
Best Practices and Provisions
Summary
Chapter 11: OLAP Reporting Advanced Techniques
Cube Dynamic Rows
Cube Dynamic Rows Expanded
Cube Restricting Rows
Cube Metadata
Cube Browser
Summary
Part IV: Enabling User Reporting
Chapter 12: Tabular Models
Introduction to PowerPivot
Importing Data into PowerPivot
PowerPivot Window
Analyzing and Enriching Data
Summary
Chapter 13: Visual Analytics with Power View
Introduction to Power View
Power View Architecture
Preparing a Model and Connection for a Tutorial
Visual Analytics with Power View
Configuring Data Source Connections
Analysis Services Tabular
Summary
Chapter 14: Report Builder Solution Strategies
Report Builder and Semantic Model History
Planning a Self-Service Reporting Environment
User Report Migration Strategies
Summary
Part V: Solution Patterns
Chapter 15: Managing Report Projects
Solutions and Projects
Version Control
Synchronizing Content
Managing Server Content
Getting Started with Azure Reporting
Summary
Chapter 16: Report Solutions, Patterns, and Recipes
Super Reports
Report Recipes: Building on Basic Skills
Summary
Part VI: Administering Reporting Services
Chapter 17: Content Management
Using Report Manager
Content Management Activities
Item-Level Security
Content Management Automation
Summary
Chapter 18: Integrating Reports with SharePoint
Native Mode Web Parts
Publishing Reports to SharePoint
Report Management
Integrated Mode Web Parts
Native Mode Versus Integrated Mode
Report Models
Summary
Chapter 19: Native Mode Server Administration
Security
Backup and Recovery
Monitoring
Configuration
Summary
Part VII: Reporting Services Custom Programming
Chapter 20: Integrating Reports into Custom Applications
URL Access
Programmatic Rendering
Using the ReportViewer Control
Summary
Chapter 21: Using Embedded and Referenced Code
Using the Expression Builder
Calculated Fields
Conditional Expressions
IIF() Is Your Friend
Using Custom Code
Summary
Chapter 22: Extending Reporting Services
Extension Through Interfaces
Creating a Custom Data Processing Extension
Summary
Part VIII: Appendixes
Appendix A: T-SQL Command Syntax Reference
T-SQL Commands, Clauses, and Predicates
Script Comment Conventions
Reserved Words
Appendix B: T-SQL System Variables and Functions
System Global Variables
System Functions
Appendix C: MDX Reference
Object Identifiers
Reserved Keywords
Member References
Sets
Tuples
The SELECT Statement
MDX Functions and Keywords
Index
Advertisements
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
Copyright
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset