Professional Microsoft SQL Server 2012 reporting services

A must-have guide for the latest updates to the new release of Reporting ServicesSQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more...

Full description

Saved in:
Bibliographic Details
Main Author: Turley, Paul
Format: eBook
Language:English
Published: Indianapolis John Wiley & Sons 2012
John Wiley & Sons, Incorporated
Wrox
Wrox/John Wiley & Sons
Edition:1
Series:Wrox programmer to programmer
Subjects:
Database management
SQL server
ISBN:1118101111, 9781118101117, 9781118237137, 1118237137, 1118262107, 1118223799, 9781118262108, 9781118223796
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Table of Contents:
  • pt. 1. Getting started -- pt. 2. Report design -- pt. 3. Business intelligence reporting -- pt. 4. Enabling user reporting -- pt. 5. Solution patterns -- pt. 6. Administering reporting services -- pt. 7. Reporting services custom programming -- part. 8. Appendix.
  • Design Surface Modifications -- Tablix -- Visualization Tweaks -- Summary -- Cube Restricting Rows -- Designing the Report -- pRowCount Parameter -- Restricting the Number of Rows in the MDX Query -- Adding pRowCount to Self-Calling Drill-Through Report Action -- A Better Way to Interact with a Report Parameter -- Summary -- Cube Metadata -- Designing the Report -- MeasureGroups -- Adding Other Cube Metadata -- Final Thoughts -- Cube Browser -- Anatomy of the Reports -- Cube Browser -- Cube Browser Metadata -- Cube Browser Member -- Behind the Scenes -- Cube Browser -- Report Body -- Restricting Rows and Columns -- Swap Actions -- Titles -- Footer Information -- Final Thoughts -- Summary -- Part IV: Enabling User Reporting -- Chapter 12: Tabular Models -- Introduction to PowerPivot -- PowerPivot for Excel -- Setup and Installation -- Importing Data into PowerPivot -- PowerPivot Window -- The Home Tab -- The Design Tab -- The Advanced Tab -- Analyzing and Enriching Data -- Filtering and Sorting -- Relationships -- Calculated Columns -- Measures -- Browsing the Model -- Summary -- Chapter 13: Visual Analytics with Power View -- Introduction to Power View -- Power View Architecture -- Architecture Overview -- Reporting Services Add-in -- Reporting Services Service Application -- PowerPivot for SharePoint -- Preparing a Model and Connection for a Tutorial -- Deploying the FAA Flight Data Model -- Creating a SharePoint Image Library for FAA Airline Images -- Publishing the FAA Workbook Directly to the PowerPivot Gallery -- Creating Data Source Connections for Power View -- BI Semantic Model (BISM) Connection File -- Report Data Source (RSDS) Connection -- Visual Analytics with Power View -- Getting Started with Power View -- Creating a New Power View Report -- Opening an Existing Power View Report -- Introduction to the Design Experience
  • Reporting Services Processors and Extensions -- The Report Processor -- Report Session Caching -- Report Execution Caching -- Snapshots -- Data Processing Extensions -- Report Items -- Rendering Extensions -- The HTML Rendering Extension -- The CSV-Rendering Extension -- The XML-Rendering Extension -- The Image-Rendering Extension -- The PDF-Rendering Extension -- The Excel-Rendering Extension -- The Word-Rendering Extension -- The Scheduling and Delivery Processor -- Delivery Extensions -- Reporting Services Application Databases -- ReportServer -- ReportServerTempDB -- Summary -- Chapter 3: Configuring SharePoint Integration -- The SharePoint Technologies -- SharePoint Foundation -- SharePoint Server -- SharePoint Web Parts -- Installation and Configuration -- Installing SharePoint Server 2010 -- Installing Service Pack (SP) 1 -- Installing and Configuring PowerPivot for SharePoint -- Installing and Configuring Reporting Services for SharePoint -- SharePoint Site Settings -- Architecture -- Summary -- Part II: Report Design -- Chapter 4: Basic Report Design -- What Good Are Wizards, Anyway? -- Building Blocks -- Following Along? -- Let's Get Started -- Touring Report Builder -- Office Tabs and Ribbons -- Home Tab -- Insert Tab -- View Tab -- Report Builder Menu -- Viewing and Setting Properties -- Data Sources -- Server Reports -- Manual Report Design -- Building a Matrix -- Wrapping It Up -- Running and Saving the Report -- Summary -- Chapter 5: Report Layout and Formatting -- Report Layout Types -- Table Reports -- Matrix Reports -- List Reports -- Chart Reports -- Gauge Reports and Dashboards -- Maps and Spatial Reports -- Defining Table Groups -- Group Expressions and Options -- Formatting Table Values -- Interactive Sort -- Adding Page Breaks -- Creating Drill-Down Reports and Dynamic Visibility -- Formatting Report Data
  • Pie and Doughnut Charts -- Bubble and Stock Charts -- Chart Type Summary -- The Anatomy of a Chart -- Creating a Multiseries Chart -- Using Multiple Chart Areas -- Useful Properties and Settings -- Control the Number of Items Displayed on an Axis -- Manage Axis Text Placement and Rotation -- Manage the Format of Axis Values -- Change the Color and Width of a Series Line -- Set a Tooltip for a Chart Value -- Control the Width and Gap Between Columns or Bars -- For a Chart with Multiple Chart Areas, Control the Exact Position of Each Chart Area -- Dynamically Increase a Chart's Size -- Summary -- Part III: Business Intelligence Reporting -- Chapter 9: BI Semantic Models -- Introduction to Data Modeling -- The BI Semantic Model -- Conceptual Architecture -- Data Model -- Business Logic and Queries -- Data Access -- The Hybrid Nature of 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 -- MDX: Simple or Complex? -- Building Queries with the MDX Query Designer -- Creating a Data Source -- Building the Dataset Query -- Using Parameterized Queries -- Modifying the MDX Query -- Adding Nonadditive Measures -- When to Use the Aggregate Function -- MDX Properties and Cube Formatting -- Drill-Through Reports -- Creating Cube Report Actions -- Parameter Safety Precautions -- Best Practices and Provisions -- Summary -- Chapter 11: OLAP Reporting Advanced Techniques -- Cube Dynamic Rows -- Cube Dynamic Rows Anatomy -- Parameters -- Dataset -- Matrix Content -- Formatting the Row Label -- Highlighting the Current Row -- Dynamic Number Formatting -- Self-Calling Drill-Through Action -- Cube Dynamic Rows Summary -- Cube Dynamic Rows Expanded -- MDX Query Modifications
  • Introduction to Dynamic Formatting -- Designing Multicolumn Reports -- Designing Gauge Reports -- Browser Compatibility -- Offline Viewing -- Rendering Format Limits and Considerations -- Summary -- Chapter 6: Designing Data Access -- Business Intelligence Reporting -- Reporting for Relational Data -- Data and Query Basics -- Data Sources -- Creating a Data Source from the Project Add Item Template -- Creating a Data Source in the Report Wizard -- Creating a Data Source When Defining a Dataset -- Data Sources and Query Languages -- T-SQL Query Design -- Data Warehouse Star Schema -- Filtering Techniques -- Filtering a Query -- Parameter Concepts -- Filtering Data with Query Parameters -- Creating a Parameter List -- Multivalue Parameters -- Cascading Parameters -- Report Parameters -- Using Stored Procedures -- Filtering Data with Report Parameters -- Using Other Data Sources -- Microsoft Access -- Building a Query in a String Expression -- Microsoft Excel -- Oracle P/L SQL -- Sybase Adaptive Server -- Federating Data Sources -- Best Practices -- Summary -- Chapter 7: Advanced Report Design -- Headers and Footers -- Aggregate Functions and Totals -- Adding Totals to a Table or Matrix Report -- Creating Report Templates -- Creating Composite Reports -- Anatomy of a Textbox -- Padding and Indenting -- Embedded Formatting -- Embedded HTML Formatting -- Designing Master/Detail Reports -- Groups and Dataset Scope -- Using a List to Combine Report Items and Data Regions -- Designing Subreports -- Federating Data with a Subreport -- Execution and Resource Implications -- Navigating Reports -- Creating a Document Map -- Links and Drill-Through Reports -- Navigating to a Bookmark -- Navigating to a URL -- Reporting on Recursive Relationships -- Summary -- Chapter 8: Chart Reports -- Chart Types -- Column Charts -- Stacked Charts -- Area and Line Charts
  • Intro -- Professional Microsoft® SQL Server® 2012 Reporting Services -- Contents -- Foreword -- Introduction -- Part I: Getting Started -- Chapter 1: Introducing Reporting Services -- Who Uses Reporting Services? -- Business Information Workers -- Business Managers -- Software Developers -- System Administrators -- Dashboards, Reports, and Applications -- Blurring the Line Between Applications and Reports -- Launching Reports from an Application -- User Interaction -- Integrating Reports and Applications -- Enterprise Reporting -- Solution Types -- Simple Report Design -- IT-Designed Reports -- User-Designed Reports -- Server-Based Reports -- Business Intelligence Reporting Solutions -- Report Data Sources -- Analytic Data Sources and Self-Service BI -- Complexity and Report Performance -- Customizing the Reporting Experience -- Summary -- Chapter 2: Reporting Services Installation and Architecture -- The Basic Installation -- Installing Reporting Services -- Installing the Reporting Services Samples and SQL Server Sample Databases -- The Enterprise Deployment -- SQL Server Editions -- Named Instances -- Topology -- Modes -- Installation Options -- Command-Line Installation -- The Reporting Life Cycle -- Authoring -- Management -- Delivery -- Reporting Services Tools -- Report Designer -- Power View -- Report Builder -- Third-Party Authoring Tools -- Report Manager -- SharePoint Libraries and Web Parts -- Reporting Services Configuration Manager -- SQL Server Management Applications -- Command-Line Utilities -- HTML Viewer -- Report Viewer Control -- Reporting Services Web Service -- Subscriptions -- Reporting Services Windows Service -- HTTP.SYS and the HTTP Listener -- The Security Sublayer -- Report Manager and the Web Service -- Core Processing -- Service Management -- Configuration Files -- WMI and the RPC Interface
  • Creating a Table Visualization