Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Title Page
Copyright Page
Dedication
Contents
Foreword
Acknowledgments
Introduction
Part I Getting Started
Chapter 1 Let’s Start at the Very Beginning
Sharing Business Intelligence
The Need to Share
Possible Solutions
Microsoft Reporting Services
Report Authoring Architecture
Report Types
Report Structure for Reporting Services Paginated Reports
Report Designer
Report Builder
Report Structure for Mobile Reports
SQL Server Mobile Report Publisher
Report-Serving Architecture
Report Server
Report Delivery
Diving In
Chapter 2 Putting the Pieces in Place: Installing Reporting Services
Preparing for the Installation
The Parts of the Whole
Editions of Reporting Services
Types of Reporting Services Installations
Installation Requirements
Other Installation Considerations
The Installation Process
The SQL Server 2016 Installation
The Reporting Services Configuration Manager
Completing a Reporting Services SharePoint Integrated Mode Installation
Installing SQL Server Data Tools
Installing SQL Server Management Studio
Common Installation Issues
Administrative Rights
Server Components Not Shown on the Feature Selection Screen
Reporting Services and IIS on the Same Server
The Repair Utility and Installation Log File
Spending Some Time in Basic Training
Part II Report Authoring
Chapter 3 DB 101: Database Basics
Database Structure
Getting Organized
Retrieving Data
Galactic Delivery Services
Company Background
Querying Data
The SELECT Query
On to the Reports
Chapter 4 A Visit to Emerald City: The Report Wizard
Obtaining the Galactic Database
Getting Started with the Authoring Environment
Creating a Project Using the Report Designer
Launching the Report Builder
Your First Report
The Customer List Report
An Interactive Table Report
The Customer-Invoice Report
Creating Matrix Reports
The Invoice-Batch Number Report
Report Parameters
The Parameterized Invoice-Batch Number Report
Flying Solo
Chapter 5 Removing the Training Wheels: Building Basic Reports
Riding Down Familiar Roads
The Transport List Report
The Tablix and Data Regions
The Repair Count By Type Report
New Territory
The Transport Information Sheet
Getting Graphical
Chapter 6 Graphic Expression: Using Charts, Images, and Gauges
Chart Your Course
The Deliveries vs. Lost Packages Chart
The Fuel Price Chart
The Fuel Price Chart, Version 2
The Business Type Distribution Chart
The Days in Maintenance Chart
The Package Weight by Planet Chart
The Discount Analysis Chart
Gauging the Results
The Digital Dashboard
Image Is Everything
Conference Nametags
Conference Place Cards
The Rate Sheet Report
From Graphical to Geo-graphical
Chapter 7 Geography Lesson: Using Maps and Spatial Data Types
Colors and Bubbles: Representing Quantities on Maps
The Earth U.S. Deliveries Map
SQL Server Spatial Data Types
The Deliveries per Planet Map
The Employee Homes Map
Building Higher
Chapter 8 Kicking It Up a Notch: Intermediate Reporting
Never Having to Say “I’m Sorry”
The Report Template
Putting the Report Template to Use
The Employee Time Report
Data Caching During Preview
The Employee List Report
The Employee Mailing Labels Report
The Overtime Report
The Revised Employee Time Report
The Revised Employee List Report
Under the Hood
Viewing the RDL
Advance, Never Retreat
Chapter 9 Beyond Wow: Advanced Reporting
Speaking in Code
The Delivery Status Report
The Lost Delivery Report
The Customer List Report—Revisited
The Delivery Trend Report
Payroll Checks
The Delivery Analysis Report
Reports Within Reports
The Employee Evaluation Report
The Invoice Report
Interacting with Reports
The Invoice Front-End Report
The Transport Monitor Report
What’s Next
Chapter 10 Make Mine to Go: Mobile Reporting
The Mobile Environment
Responsive Rendering
Adaptive Rendering
Getting Started with Mobile Report Publisher
Installing Mobile Report Publisher
Launching Mobile Report Publisher
Our First Mobile Report: The Mobile Dashboard
Mobile Reports with Navigators
The Delivery Analysis Mobile Report
Package Weight by Planet Mobile Report
Mobile Reports with Drillthrough
Employee Hours by Hub Mobile Reports
Mobile Report Publisher Report Settings
Layout Grid Resolution
Settings Tab
Time to Be Served
Part III Report Serving
Chapter 11 Traveling Portal-to-Portal: The Reporting Services Web Portal
Folders
The Web Portal
Moving Reports and Supporting Files to the Report Server
Deploying Reports Using the Report Designer
Uploading Reports Using the Web Portal
Uploading Other Items Using the Web Portal
Modifying Reports from the Report Server
Managing Items in Folders
Moving Items Between Folders
Deleting a Folder
Renaming a Folder
Seek and Ye Shall Find: Search and Find Functions
Searching for a Report
Finding Text Within a Report
Report Output Formats
Exporting Reports in Other Formats
The Atom Data Feed
Printing from the Web Portal
Managing Reports on the Report Server
Security
Roles
Linked Reports
Creating a Linked Report
Key Performance Indicators in the Web Portal
Creating KPIs in the Web Portal
Reporting Services in SharePoint Integrated Mode
Creating a Document Library
Deploying a Report to a Document Library
Managing Reports
Security Roles
Data Alerts
Delivering the Goods
Chapter 12 Delivering the Goods: Report Delivery
The Joy of Sharing
Shared Datasets
Report Parts
Using Shared Datasets and Report Parts Wisely
Caching In
Report Caching
Enabling Report Caching
Report Snapshots
Enabling Report Snapshots
Cache Refresh Options
Cache Refresh Plans
Report History
Enabling Report History
Managing Report History Snapshots
Updating Report Definitions and Report History Snapshots
Subscriptions
Standard Subscriptions
Managing Your Subscriptions
Data-Driven Subscriptions
Site Settings
The General Site Settings Page
Branding Site Settings Page
Managing Brand Packages
Other Pages Accessed from the Site Settings Page
Managing Reporting Services Through the SQL Server Management Studio
Additional Settings
Building On
Chapter 13 Teamwork: Integrating Reporting Services
Using Reporting Services Without the Web Portal
URL Access
Web Service Access
The Report Viewer Control
SharePoint Web Parts
Pinning SSRS Visualizations to Power BI
Reporting Services Utilities
Best Foot Forward
Chapter 14 Well Begun: Best Practices
Report Authoring Practices
Use Report Templates
Use Shared Data Sources
Use Views and Stored Procedures
Use Navigation Features
Report Deployment Practices
Create a Backup of the Encryption Key
Review Reports Before Deploying
Use Linked Reports
Use Folders and Descriptions to Organize Reports
Assign Security at the Folder Level
Assign Security to Domain Groups
Assign Only the Rights Needed
Hide Items
Deploy Supporting Items to the Report Server
Use Caching and Snapshots
Where Do We Go from Here?
Index
← Prev
Back
Next →
← Prev
Back
Next →