You are previewing Reporting with Microsoft SQL Server 2012.
O'Reilly logo
Reporting with Microsoft SQL Server 2012

Book Description

Learn to quickly create reports in SSRS and Power View as well as understand the best use of each reporting tool

In Detail

Reporting with Microsoft SQL Server 2012 will cover all the features of SSRS and Power View and will provide a step-by-step lab activity to help you develop reports very quickly.

Starting with the difference between standard and self- service reporting, this book covers the main features and functionality offered in SQL Server Reporting Services 2012 including a breakdown of the report components, development experience, extensibility, and security. You will also learn to set up and use Power View within Excel and SharePoint and connect to a tabular model as well as a multidimensional model. The book provides real-life reporting scenarios that help to clarify when those scenarios are discussing standard reporting, in which case SSRS is the best choice, and when they are discussing self-service reporting, in which case Power View is the best choice.

This book will have you creating reports in SSRS and Power View in no time!

What You Will Learn

  • Get to grips with reporting scenarios that describe the best reporting tool to use
  • Follow the step-by-step exercises to build a report in SSRS and Power View
  • Visualize and interact with data in bold new ways with Power View
  • Generate reports quickly using intuitive interfaces
  • Create self-service reports with a wide variety of formats
  • Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at If you purchased this book elsewhere, you can visit and register to have the files e-mailed directly to you.

    Table of Contents

    1. Reporting with Microsoft SQL Server 2012
      1. Table of Contents
      2. Reporting with Microsoft SQL Server 2012
      3. Credits
      4. About the Authors
      5. About the Reviewers
        1. Support files, eBooks, discount offers, and more
          1. Why subscribe?
          2. Free access for Packt account holders
          3. Instant updates on new Packt books
      7. Preface
        1. What this book covers
        2. What you need for this book
        3. Who this book is for
        4. Conventions
        5. Reader feedback
        6. Customer support
          1. Errata
          2. Downloading the color images of the book
          3. Piracy
          4. Questions
      8. 1. Getting Started with Reporting
        1. Standard reporting with SSRS
        2. Self-service reporting with Power View
        3. Power View limitations
        4. Reporting scenarios
          1. Scenario 1
          2. Scenario 2
          3. Scenario 3
          4. Scenario 4
          5. Scenario 5
          6. Scenario 6
          7. Scenario 7
          8. Scenario 8
          9. Scenario 9
          10. Scenario 10
          11. Scenario 11
          12. Scenario 12
          13. Scenario 13
        5. Summary
      9. 2. SSRS – Standard Reporting
        1. Primary components of a report
          1. Data source
          2. Dataset
          3. Report items
        2. Additional components of a report
          1. Report parameters
          2. Expressions
          3. Actions
          4. Custom code
        3. Report development environment
        4. Server features and functionality
          1. Choosing an installation mode – SharePoint Integrated versus Native
          2. Scheduling
            1. Subscriptions
            2. Report snapshots
            3. Caching
          3. Data alerts
          4. My Reports (Native mode only)
          5. Linked reports (Native mode only)
        5. Consuming reports
          1. Online
          2. Offline
          3. Data feed
          4. Extensibility
          5. Security
            1. Roles and permissions
            2. Securing Report Server objects
            3. Data security
        6. Summary
      10. 3. Development Activity with SSRS
        1. Prerequisites
        2. Tutorial scenario
          1. Creating a Reporting Services project
          2. Creating a report object
          3. Creating a shared data source
          4. Adding reference to shared data source
          5. Creating a dataset
          6. Adding a report item
          7. Deploying a report project
        3. Summary
      11. 4. Power View – Self-service Reporting
        1. Getting started
        2. PowerPivot
        3. Business Intelligence Semantic Model
        4. Power View within SharePoint
          1. Setup
          2. Tabular model connection
          3. Starting Power View connected to a tabular model connection
          4. Multidimensional model connection
          5. Starting Power View connected to a multidimensional model connection
        5. Power View within Excel 2013
          1. Setup
          2. Data models
          3. Starting Power View in Excel
          4. Importing data into Excel
            1. Adding data to a worksheet and inserting data into Power View
            2. Not adding data to a worksheet and inserting data into Power View
            3. Adding data to a worksheet and using PowerPivot
            4. Not adding data to a worksheet and using PowerPivot
        6. Data visualizations
        7. The user interface
        8. Enhancing data models
        9. Deploying and sharing reports
        10. Presentation modes
        11. Reports with multiple views in Power View
          1. Adding multiple views
          2. Navigating among views
          3. View filters
          4. View preview images
        12. Chart highlighting, slicers, and filtering
          1. Chart highlighting
          2. Slicers
          3. Filtering
            1. View-level/sheet-level filters
            2. Visualization-level filters
            3. Basic filters
            4. Advanced filters
            5. Search in filters
        13. Sorting
        14. Export reports to Microsoft Office PowerPoint
        15. Design tips
          1. Undo/Redo
          2. Arranging visualizations
          3. Fit to window
          4. Pop out
        16. Summary
      12. 5. Development Activity with Power View
        1. Prerequisites
        2. Tutorial scenario
          1. Creating a BI Semantic Model (BISM) connection
          2. Opening the Power View design interface
          3. Creating bar charts
          4. Creating pie charts
          5. Creating column charts
          6. Adding a slicer
          7. Deploying reports to SharePoint
        3. Summary
      13. Index