Microsoft SQL Server 2012 Reporting Services

Book description

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

  • Table of contents

    1. Microsoft SQL Server 2012 Reporting Services
    2. Dedication
    3. Introduction
      1. Who should read this book
        1. Assumptions
      2. Organization of this book
      3. Conventions and features in this book
      4. System requirements
      5. Code samples
        1. Installing the code samples
      6. Acknowledgments
      7. Errata & book support
      8. We want to hear from you
      9. Stay in touch
    4. I. Getting started with Reporting Services
      1. 1. What’s new in Microsoft SQL Server 2012 Reporting Services
        1. Introducing new features
          1. Power View
            1. Data sources
            2. Data visualization
            3. Interactive scatter chart
            4. Multiples
            5. Highlighted values
            6. Slicer
            7. Tiles
            8. View filter
            9. Visualization filter
            10. Report sharing
          2. SharePoint integration
          3. Data alerts
            1. Data Alert Designer
            2. Data Alert Manager
        2. Reviewing other changes
          1. SQL Server Data Tools
          2. New rendering extensions
            1. Excel 2010 renderer
            2. Word 2010 renderer
        3. Parting with Report Builder 1.0
        4. Upgrading from prior versions
          1. Preparation
          2. In-place upgrade
            1. Native-mode report server upgrade
            2. SharePoint integrated-mode report server upgrade
            3. Reports upgrade
          3. Migration
            1. Native-mode report server migration
            2. SharePoint integrated-mode report server migration
      2. 2. Introducing the Reporting Services environment
        1. A reporting platform
        2. Reporting life cycle
          1. Report development
          2. Report administration
          3. Report access
        3. Reporting Services architecture
          1. Native mode
            1. Data tier
            2. Application tier
            3. Server tier
            4. Service architecture
          2. SharePoint integrated mode
            1. Data tier
            2. Application tier
            3. Server tier
      3. 3. Understanding deployment scenarios
        1. Single-server deployment
          1. Memory
          2. Disk space
          3. Disk activity
        2. Distributed deployment
          1. Native-mode distribution
          2. SharePoint integrated-mode distribution
          3. Other components
        3. Scale-out deployment
          1. Load balancing
          2. Failover cluster
          3. Distributed workload
        4. Internet deployment
      4. 4. Installing Reporting Services
        1. Reviewing hardware and software requirements
          1. Selecting an operating system
          2. Choosing a Database Engine edition
          3. Reviewing SharePoint integrated-mode requirements
        2. Planning accounts for reporting services
        3. Performing the installation
          1. Installing prerequisites
          2. Installing SQL Server 2012
            1. Product key
            2. License terms
            3. Setup role
            4. Feature selection
            5. Installation rules
            6. Instance configuration
            7. Disk space requirements
            8. Server configuration
            9. Database Engine configuration
            10. Analysis Services configuration
            11. Reporting Services configuration
            12. Installation configuration rules
        4. Configuring native-mode Reporting Services
          1. Service account
          2. Web service URL
          3. Database
          4. Report Manager URL
          5. Email settings
          6. Execution account
          7. Encryption keys
          8. Scale-out deployment
        5. Configuring partial integration with SharePoint
        6. Configuring SharePoint for local mode reporting
        7. Configuring SharePoint integrated mode
          1. Installing the Reporting Services Add-in for SharePoint
          2. Creating a SharePoint web application
          3. Creating a business intelligence center site
          4. Configuring SharePoint for Reporting Services integration
            1. Configuring the service application
            2. Provisioning subscriptions and alerts
            3. Configuring a SharePoint site
            4. Adding another report server
            5. Adding another Reporting Services web front-end
        8. Installing Report Builder
        9. Installing sample databases
      5. 5. Exploring Reporting Services fundamentals
        1. Understanding design environments
          1. Comparing design environments
          2. Choosing a report designer
            1. Using Report Designer
            2. Using Report Builder
            3. Using Power View
        2. Developing a report with Report Builder
          1. Launching Report Builder
            1. Native mode
            2. SharePoint integrated-mode
            3. Stand-alone application
          2. Getting Started Wizard
          3. Using the dataset designer
          4. Getting familiar with the Report Builder interface
          5. Adding a data source
          6. Adding a dataset
          7. Adding a report title
          8. Using data region wizards
            1. Table Or Matrix Wizard
            2. Chart Wizard
            3. Map Wizard
          9. Adding a data region manually
          10. Adding fields to a table
            1. Dragging fields from the Report Data pane
            2. Using the Field List icon
          11. Adding a total
          12. Grouping data
          13. Inserting page breaks
          14. Formatting a report
          15. Previewing a report
          16. Saving a report
        3. Managing a report
          1. Publishing a report
            1. Publishing to a native-mode report server
            2. Publishing to a SharePoint integrated-mode report server
          2. Adding a description
          3. Reviewing processing options
            1. Reviewing processing options in Report Manager
            2. Reviewing processing options in a SharePoint document library
        4. Viewing a report
          1. Opening a report
            1. Opening a report in Report Manager
            2. Opening a report in a SharePoint document library
          2. Using the HTML Viewer
    5. II. Developing reports
      1. 6. Planning your report design
        1. Knowing your audience
        2. Reviewing report options
          1. Layout decisions
          2. Data considerations
          3. Parameters
          4. Mobile devices
          5. Printed reports
        3. Developing standards
      2. 7. Working with report server projects
        1. Getting started with report server projects
          1. Creating a Reporting Services project
            1. Creating a new project and solution
            2. Adding a new project to an existing solution
            3. Adding an existing project to an existing solution
          2. Selecting a project type
            1. Report Server Project Wizard
            2. Report Server project
          3. Getting familiar with the Visual Studio interface
            1. Solution Explorer
            2. Properties window
            3. Output window
            4. Error List window
            5. Toolbox window
            6. Report Data window
          4. Removing a project from a solution
        2. Working with report project files
          1. Reviewing report project file types
          2. Using the Report Wizard
            1. Initial steps
            2. Tabular report
            3. Matrix report
            4. Final steps
          3. Adding a new item to a project
          4. Adding an existing item to a project
          5. Removing an item from a project
        3. Using report project commands
          1. Project menu
          2. Build menu
        4. Configuring report project properties
          1. Working with project configurations
          2. Setting project properties
      3. 8. Retrieving data for a report
        1. Understanding data source types
          1. Relational data sources
            1. SQL Server
            2. SQL Azure
            3. SQL Server Parallel Data Warehouse
            4. Oracle
            5. Teradata
            6. OLE DB
            7. ODBC
          2. Multidimensional data sources
            1. SQL Server Analysis Services
            2. SAP NetWeaver BI
            3. Hyperion Essbase
          3. Miscellaneous data sources
            1. XML
            2. SharePoint list
            3. Report server model
        2. Connecting to data with data sources
          1. Comparing embedded and shared data sources
          2. Working with an embedded data source
            1. Creating an embedded data source
            2. Processing queries as a single transaction
            3. Editing an embedded data source
            4. Converting an embedded data source to a shared data source
            5. Deleting an embedded data source
          3. Working with a shared data source
            1. Creating a shared data source
            2. Referencing a shared data source in a report
            3. Editing a shared data source
            4. Deleting a shared data source
          4. Setting data source credentials
            1. Integrated security
            2. User name and password
            3. Prompt for credentials
            4. No credentials
        3. Retrieving data with datasets
          1. Comparing embedded and shared datasets
          2. Working with an embedded dataset
            1. Creating an embedded dataset
            2. Editing an embedded dataset
            3. Converting an embedded dataset to a shared dataset
            4. Deleting an embedded dataset
          3. Working with a shared dataset
            1. Creating a shared dataset
            2. Referencing a shared dataset in a report
            3. Editing a shared dataset
            4. Deleting a shared dataset
          4. Exploring query designers
            1. Graphical query designer
            2. Report model query designer
            3. SharePoint list query designer
            4. MDX query designer
            5. Text-based query designer
          5. Understanding dataset properties
            1. Fields
            2. Options
            3. Filters
            4. Parameters
      4. 9. Designing the report layout
        1. Reviewing report items
          1. General report items
            1. Text boxes
            2. Lines and rectangles
            3. Images
            4. Subreports
          2. Tablix data regions
            1. Table
            2. Matrix
            3. List
          3. Graphical data regions
            1. Chart
            2. Gauge
            3. Map
            4. Data bar
            5. Sparkline
            6. Indicator
        2. Adding general report items to a report
          1. Adding a text box
          2. Adding a line
          3. Adding a rectangle
          4. Adding an image
            1. Embedded image
            2. External image
            3. Database images
          5. Adding a subreport
        3. Working with data regions
          1. Adding a table
          2. Binding data to a data region
          3. Grouping data
          4. Adding a total to a table
          5. Adding a matrix
          6. Sorting groups
          7. Adding a list
        4. Using properties to control appearance and behavior
          1. Configuring the placement and size of a report item
            1. Setting the Location property
            2. Setting the Size property
            3. Controlling text box growth
          2. Changing the appearance of a report item
            1. Setting font properties
            2. Setting selected text properties
            3. Setting alignment properties
            4. Setting the Format property
            5. Setting locale properties
            6. Setting border properties
            7. Setting fill properties
            8. Setting list properties
            9. Setting line properties
      5. 10. Working with the tablix
        1. Exploring the tablix
          1. What is a tablix?
          2. Tablix data regions
            1. Table
            2. Matrix
            3. List
          3. Tablix cells
            1. Cell content
            2. Cell scope
            3. Cell merge and split
        2. Transforming a tablix
          1. Table to matrix
          2. Matrix to table
          3. Detail list to grouped list
        3. Configuring tablix properties
          1. No data rows
          2. Groups before row header
          3. Sort
        4. Working with tablix groups
          1. Row groups
            1. Separate columns for each group
            2. Single column for each group
          2. Static columns
            1. Repeating static columns
            2. Adjacent columns
          3. Adjacent groups
          4. Group properties
            1. Missing group values in nested data regions
            2. Recursive hierarchy groups
      6. 11. Developing expressions
        1. Introducing expressions
          1. Simple expressions
            1. Dataset field placeholder
            2. Aggregate function placeholder
            3. Built-in field placeholder
            4. Parameter value placeholder
          2. Complex expressions
        2. Using the Expression dialog box
          1. Opening the Expression dialog box
          2. Exploring the Category tree
          3. Using IntelliSense
            1. Member or property selection
            2. Function tooltip
            3. Syntax error
        3. Using built-in collections
          1. DataSets collection
          2. DataSources collection
          3. Fields collection
          4. Globals collection
          5. Parameters collection
          6. ReportItems collection
          7. User collection
          8. Variables collection
        4. Working with expressions
          1. Adding calculations to a report
            1. Calculated fields
            2. Text box expressions
            3. Report item references
            4. Built-in fields
          2. Applying conditional formatting
          3. Working with variables
            1. Group variables
            2. Report variables
            3. DeferVariableEvaluation property
          4. Using expressions for dynamic connections and datasets
            1. Dynamic connection strings
            2. Dynamic query strings
      7. 12. Using functions
        1. Getting help for functions
          1. Function description and syntax
          2. Function tooltip
        2. Using text functions
          1. The character functions
            1. The Asc and AscW functions
            2. The Chr and ChrW functions
            3. The Space function
          2. The search functions
            1. The Filter function
            2. The GetChar function
            3. The InStr and InStrRev functions
          3. The formatting functions
            1. The Format function
            2. The FormatCurrency, FormatNumber, and FormatPercent functions
            3. The FormatDateTime function
          4. The array functions
            1. The Join function
            2. The Split function
          5. The conversion functions
            1. The LCase and UCase functions
            2. The StrConv function
          6. The string manipulation functions
            1. The Left, LSet, Right, and RSet functions
            2. The Mid function
            3. The StrDup function
            4. The StrReverse function
          7. The string evaluation functions
            1. The Len function
            2. The StrComp function
          8. The cleanup functions
            1. The Replace function
            2. The Trim, LTrim and RTrim functions
        3. Using date and time functions
          1. The date calculation functions
            1. The DateAdd function
            2. The DateDiff function
          2. The date manipulation functions
            1. The DatePart function
            2. The interval functions
          3. The date conversion functions
            1. The DateSerial and TimeSerial functions
            2. The DateValue and TimeValue functions
            3. The MonthName and WeekdayName functions
          4. The current date and time functions
        4. Using math functions
          1. The trigonometry functions
          2. The sign functions
          3. The exponent functions
          4. The rounding functions
          5. Other math functions
        5. Using inspection functions
        6. Using program flow functions
          1. The Choose function
          2. The Iif function
          3. The Switch function
        7. Using aggregate functions
          1. The aggregate functions
          2. The Scope argument
          3. The RunningValue function
        8. Using financial functions
        9. Using conversion functions
        10. Using miscellaneous functions
          1. The InScope function
          2. The lookup functions
            1. The Lookup function
            2. The MultiLookup function
            3. The LookupSet function
          3. The row functions
            1. The Previous function
            2. The RowNumber function
        11. Working with hierarchical data
          1. The Level function
          2. The Recursive keyword
      8. 13. Adding interactivity
        1. Interacting with the report layout
          1. Interactive sorting
            1. Sort detail rows
            2. Sort groups
            3. Sort by expression
            4. Apply sort to other groups and data regions
          2. Using fixed headers
          3. Configuring visibility
            1. Show or hide a row
            2. Drilldown
          4. Adding tooltips
        2. Adding navigation features
          1. Defining a document map
            1. Creating a document map
            2. Customizing a document map
            3. Showing and hiding a document map
            4. Rendering a document map
          2. Using embedded HTML tags
          3. Working with report actions
            1. Go to report
            2. Go to bookmark
            3. Go to URL
      9. 14. Creating dynamic reports with parameters
        1. Working with report parameters
          1. Creating a report parameter
          2. Setting report parameter properties
            1. General properties
            2. Available values
            3. Default values
            4. Advanced parameter options
          3. Deleting a report parameter
          4. Displaying parameter selections in a report
        2. Using filters
          1. Creating a filter
            1. Filtering a dataset
            2. Filtering a data region
            3. Filtering a group
          2. Using a report parameter as a filter
          3. Understanding filter operators
            1. Equality and inequality
            2. Like
            3. Top and bottom
            4. Between
            5. In
            6. Not in
          4. Applying OR logic to multiple filters
        3. Using parameters with subreports and drillthrough
          1. Passing a parameter to a subreport
          2. Passing a parameter to a drillthrough report
            1. Configuring the drillthrough report parameter value
            2. Omitting a parameter
        4. Working with query parameters
          1. Creating a query parameter
          2. Linking report and query parameters
          3. Deleting a query parameter
        5. Cascading parameters
          1. Creating a child report parameter dataset
          2. Linking a parent report parameter to a query parameter
          3. Changing parameter order
      10. 15. Managing the page layout
        1. Understanding rendering
          1. Reviewing rendering formats by pagination type
          2. Using the RenderFormat global variable
        2. Adjusting the report size
          1. Understanding the page structure properties
            1. Report page structure
            2. Page size properties
            3. Column properties
            4. White space
          2. Using device information to change page properties
        3. Working with the page header and footer
          1. Adding a page header or footer
          2. Configuring page header or footer properties
          3. Using expressions in a page header or footer
            1. Page headers and footers in Word
            2. Page headers and footers in Excel
          4. Removing a page header or footer
        4. Configuring page breaks
          1. Creating page breaks
          2. Using the KeepTogether property
          3. Adding page breaks by group
          4. Repeating headers
          5. Numbering pages
            1. Global variables
            2. ResetPageNumber property
          6. Naming pages
      11. 16. Using Analysis Services as a data source
        1. Creating an Analysis Services dataset
          1. Analysis Services data source
          2. MDX graphical query designer
            1. Metadata pane
            2. Data pane
            3. Filter pane
            4. Toolbar
            5. Query mode
            6. Calculated Member Builder
        2. Building a report
          1. Analysis Services dataset fields
          2. Extended field properties
          3. Aggregate function
          4. Aggregate values in detail rows
          5. Show Aggregations button
        3. Designing parameters
          1. Auto-generated query and report parameters
            1. Filter pane
            2. Report parameter
            3. Available values dataset
            4. Calculated field
            5. Parameterized dataset
          2. Custom query parameter
            1. Query parameter
            2. MDX query parameterization
            3. Query parameter value
            4. Report parameter
            5. Calendar control
    6. III. Adding data visualizations
      1. 17. Creating charts
        1. Adding a chart to a report
          1. Selecting a chart type
          2. Understanding chart types
            1. Linear data
            2. Ratio data
            3. Multivalue data
        2. Using the chart data pane
          1. Values
            1. Field selection
            2. Value aggregation
            3. Fields
            4. Series properties
          2. Category groups
            1. Field selection
            2. Category group properties
          3. Series groups
            1. Field selection
            2. Series group properties
        3. Formatting chart elements
          1. Chart
          2. Chart title
          3. Axis title
          4. Axes
          5. Series labels
          6. Legend
        4. Working with data bars
          1. Adding a data bar
          2. Configuring data bar properties
            1. Data bar length
            2. Data bar appearance
        5. Working with sparklines
          1. Adding a sparkline
          2. Configuring sparkline properties
            1. Sparkline appearance
            2. Sparkline axes alignment
      2. 18. Working with chart elements
        1. Changing color palettes
          1. Built-in color palettes
          2. Custom color palette
        2. Working with vertical axis properties
          1. Scale break
          2. Logarithmic scale
        3. Working with horizontal axis properties
          1. Axis type
          2. Intervals
            1. Interval properties
            2. Interlacing
        4. Working with series properties
          1. Empty points
            1. Marker
            2. Empty point color
            3. Zero value
          2. Bubble charts
          3. Calculated series
          4. Secondary axis
          5. Multiple chart types
          6. Multiple chart areas
        5. Working with pie charts
          1. Slice consolidation
          2. Secondary pie chart
      3. 19. Comparing values to goals with gauges
        1. Adding a gauge to a report
          1. Understanding gauge types
          2. Creating a gauge
            1. Radial gauges
            2. Linear gauges
        2. Working with gauge elements
          1. Understanding gauge elements
          2. Pointer
            1. Value
            2. Pointer properties
            3. Custom pointer
            4. Snapping interval
          3. Scale
            1. Scale properties
            2. Multiple scales
          4. Range
            1. Range properties
            2. Multiple ranges
          5. Gauge
            1. Radial gauge properties
            2. Linear gauge properties
            3. Common gauge properties
          6. Gauge label
          7. Gauge panel
        3. Grouping gauges
          1. Multiple gauges in a gauge panel
            1. Adjacent gauges
            2. Child gauges
          2. Repeating gauges
      4. 20. Displaying performance with indicators
        1. Adding an indicator to a report
          1. Understanding indicator types
          2. Creating an indicator
        2. Configuring an indicator
          1. Assigning an indicator value
          2. Defining indicator properties
            1. General properties
            2. Value and states
            3. Synchronization scope
          3. Grouping indicators
            1. Adjacent indicators
            2. Gauge and indicator
            3. Gauge with child indicator
        3. Customizing indicators
          1. Using customized images
          2. Adding labels
          3. Adjusting location and size
          4. Dynamic sizing
      5. 21. Mapping data
        1. Understanding spatial data
          1. Types of spatial data
            1. Points
            2. Lines
            3. Polygons
          2. SQL Server spatial data types
            1. Geometry
            2. Geography
        2. Using the Map Wizard
          1. Selecting a spatial data source
            1. Map Gallery
            2. ESRI shapefile
            3. Spatial query
          2. Choosing spatial data and map view options
            1. Spatial field and layer type
            2. Center point
            3. Zoom factor
            4. Map resolution
            5. Embedded map data
            6. Bing Maps layer
          3. Choosing map visualization
            1. Point data maps
            2. Line data maps
            3. Polygon data maps
          4. Adding an analytical data set
          5. Setting theme and data visualization options
            1. Basic marker map
            2. Bubble marker map
            3. Analytical marker map
            4. Line map
            5. Line analytical map
            6. Basic polygon map
            7. Color analytical map
            8. Bubble map for polygons
        3. Finalizing the map
          1. Map preview
          2. Simple adjustments
            1. Map title
            2. Legend
            3. Scales
      6. 22. Working with map elements
        1. Configuring map elements
          1. Map
          2. Viewport
            1. Center and zoom
            2. Parallels and meridians
            3. Viewport coordinate system, projection, and boundaries
            4. Optimization
          3. Map title
          4. Legend
          5. Scales
            1. Color scale
            2. Distance scale
        2. Working with map layers
          1. Map Layers pane
          2. Map layer properties
          3. Common spatial element properties
          4. Color rules
            1. Colors
            2. Distribution
            3. Legend options
          5. Point maps
            1. Point properties
            2. Point color rule
            3. Point size rule
            4. Marker type rule
          6. Line maps
            1. Line properties
            2. Line color rule
            3. Line width rule
          7. Polygon maps
            1. Polygon properties
            2. Polygon color rule
            3. Center points
          8. Tile layer maps
        3. Inserting custom points
        4. Understanding order of precedence
    7. IV. Managing the report server
      1. 23. Deploying reports to a server
        1. Deploying content
          1. Deploying a report project
            1. Deployment from SSDT
            2. Deployment verification
          2. Saving a report from Report Builder
          3. Uploading a report
          4. Using the rs utility
          5. Deploying a report model
        2. Managing content
          1. Using folders to organize content
          2. Moving content
          3. Creating a linked report
          4. Copying a report
          5. Configuring report parameters
        3. Configuring data source properties
          1. Selecting a data source for a report
          2. Sending credentials to a data source
            1. Windows integrated security
            2. Prompted credentials
            3. No credentials
            4. Stored credentials
        4. Configuring report processing options
          1. Executing a report on demand
          2. Caching reports
          3. Configuring report time-out
          4. Refreshing the cache
        5. Working with snapshots
          1. Creating report snapshots
          2. Saving report snapshots in report history
      2. 24. Securing report server content
        1. Configuring report server security policies
          1. Understanding authentication types
          2. Reviewing default authorization policies
            1. Native-mode roles
            2. SharePoint integrated-mode groups and permission levels
        2. Assigning user permissions
          1. Native-mode role assignments
          2. SharePoint permission-level assignments
        3. Configuring item-level security
          1. Securing folders and document libraries
            1. Native-mode folder security
            2. SharePoint integrated-mode document library security
            3. SharePoint integrated-mode folder security
          2. Approving data sources in SharePoint integrated mode
          3. Securing an item
          4. Assigning a system role
          5. Securing a report model
        4. Implementing data security
          1. Using a query parameter and a role to secure data
          2. Using a permissions table to secure data
          3. Using a dataset filter to secure data
      3. 25. Performing administrative tasks
        1. Configuring the report server
          1. Updating report server properties
            1. General properties
            2. Execution properties
            3. History properties
            4. Logging properties
            5. Security properties
            6. Advanced properties
          2. Managing encrypted information
          3. Configuring authentication
          4. Managing memory
          5. Disabling report server features
          6. Disabling an extension
        2. Managing the report server
          1. Canceling jobs
          2. Suspending report execution
          3. Performing backup and recovery
            1. Native-Mode report server database
            2. SharePoint integrated-mode report server database
            3. Encryption keys
            4. Configuration files
        3. Monitoring the report server
          1. Checking the application database size
          2. Monitoring the Windows application event log
          3. Using the trace logs
          4. Adding the HTTP log
          5. SharePoint diagnostic logging
          6. Execution logging
          7. Using the ExecutionLog3 view
          8. Using performance counters
    8. V. Viewing reports
      1. 26. Accessing reports online
        1. Using Report Manager
          1. Searching for a report
          2. Using the HTML Viewer
          3. Using the document map
          4. Printing a report
          5. Using the My Reports folder
        2. Accessing reports in SharePoint
          1. Searching for a report
          2. Using the SharePoint Report Viewer
          3. Creating a dashboard
            1. Create a Web Part page
            2. Add a SQL Server Reporting Services Report Viewer Web Part
            3. Configure the Web Part
        3. Exporting reports
          1. Using soft page-break renderers
            1. Excel format
            2. Word format
            3. MHTML format
          2. Using hard page-break renderers
            1. PDF format
            2. TIFF format
          3. Exporting a report for data exchange
            1. CSV format
            2. XML format
            3. ATOM format
      2. 27. Working with subscriptions
        1. Creating a shared schedule
          1. Schedules list
          2. New schedule
        2. Creating standard subscriptions
          1. New subscription
          2. Delivery providers
            1. Email delivery
            2. Windows file share delivery
            3. Null Delivery Provider
            4. SharePoint Document Library
          3. Report parameter values
          4. Subscription processing options
        3. Creating data-driven subscriptions
          1. Creating a subscription delivery table
          2. Configuring data-driven subscription settings
            1. Native mode
            2. SharePoint integrated mode
        4. Managing subscriptions
          1. Using the My Subscriptions page
          2. Deleting a subscription
            1. Native mode
            2. SharePoint integrated mode
      3. 28. Data alerting
        1. Understanding the data alerting architecture
          1. Data alert workflow
          2. Alerting service
        2. Creating data alerts
          1. SharePoint Report Viewer
          2. Data feeds
          3. Data alert rules
            1. Rule scope
            2. Rule condition
            3. Multiple rules
            4. Data alert condition removal
          4. Schedule settings
          5. Email settings
        3. Receiving data alerts
          1. Successful alert
          2. Alert failure
        4. Managing alerts
          1. Alert status
          2. Edit command
          3. Delete command
          4. Run command
        5. Configuring data alerting
          1. RsReportServer.Config file settings
            1. IsAlertingService flag
            2. Alerting interval defaults
          2. SharePoint configuration database settings
        6. Monitoring the alerting process
          1. Execution log
          2. Alerting stored procedures
          3. Performance counters
    9. VI. Ad hoc reporting
      1. 29. Reusing report parts
        1. Introducing report parts
          1. Report part
          2. Report part benefits
        2. Deploying report parts
          1. Deployment from SSDT
          2. Deployment from Report Builder
          3. Redeployment of a report part
          4. Report part management on the report server
        3. Using report parts
          1. Report Part Gallery
          2. Update notification
        4. Choosing report parts vs. subreports
      2. 30. Preparing to use Power View
        1. Using tabular models with Power View
          1. Introducing tabular models
          2. Creating a BI Semantic Model connection
        2. Enhancing tabular models for Power View
          1. Summarizing values
          2. Formatting values
          3. Setting the default sort
          4. Marking the date table
          5. Managing grouping behavior
          6. Adding images
            1. Using binary data
            2. Using external images
          7. Improving the appearance of identifying information
          8. Simplifying the creation of a new table
      3. 31. Using Power View
        1. Getting started with Power View
          1. Verifying browser requirements
          2. Connecting to a data source
            1. PowerPivot Gallery
            2. Reporting Services shared data source
            3. BI Semantic Model connection file
          3. Getting familiar with the design environment
            1. View workspace
            2. Views pane
            3. Ribbon
            4. Field list
            5. Layout section
        2. Visualizing data
          1. Table
            1. Table columns
            2. Table layout section
            3. Table sort order
          2. Matrix
            1. Matrix row and column groups
            2. Matrix layout section
          3. Charts
            1. Column, bar, and line charts
            2. Column, bar, and line chart layout section
            3. Column and bar chart sort order
            4. Multiples
            5. Scatter chart layout section
            6. Play axis
          4. Cards
        3. Filtering data
          1. Highlighted values
          2. Slicer
          3. Tiles
            1. Tile By area
            2. Tile visualization mode
            3. Multiple visualizations in a tiles container
            4. Synchronization
          4. View filter
            1. Basic filter mode
            2. Advanced filter mode
        4. Selecting a display mode
        5. Saving a Power View report
          1. File save options
          2. PowerPoint export
    10. VII. Using Reporting Services as a development platform
      1. 32. Understanding Report Definition Language
        1. Introducing Report Definition Language
          1. RDL schema definition
          2. RDL usage
        2. Exploring key elements
          1. Report element
          2. DataSources and DataSource elements
          3. DataSets and DataSet elements
          4. Tablix element
        3. Working with RDL
          1. Manual RDL edits
          2. Programmatic RDL edits
          3. RDL generation
            1. Solution overview
            2. RDLGenerator class
            3. Solution deployment
      2. 33. Programming report design components
        1. Embedding code in a report
          1. Code property
          2. Custom function call
        2. Using assemblies to share custom code
          1. Class library
            1. Class definition
            2. Custom assembly digital signature
            3. Assembly deployment
          2. Custom assembly call
        3. Creating a custom data processing extension
          1. Data processing extension overview
          2. Data processing extension development
            1. Assembly properties
            2. Connection class
            3. Command class
            4. DataReader class
            5. Parameter class
            6. ParameterCollection class
            7. Transaction class
          3. Data processing extension deployment
            1. Custom extension digital signature
            2. File locations
            3. Configuration changes
            4. Implementation
      3. 34. Programming report server management
        1. Scripting administrative tasks
          1. Deploying reports
            1. DeployReports.rss script walkthrough
            2. DeployReports.rss script execution
          2. Creating a linked report
            1. CreateLinkedReport.rss script walkthrough
            2. CreateLinkedReport.rss script execution
        2. Working with configuration settings
          1. Using the WMI provider
            1. WMI provider application walkthrough
            2. WMI provider application execution
          2. Using Windows PowerShell cmdlets
        3. Using the web service
          1. Web.config
          2. References
          3. Initial variable declarations
          4. Page load
          5. Recipient list
          6. Schedule list
          7. Report list
          8. Subscription creation
          9. Web application execution
      4. 35. Programming report access
        1. Linking to reports with URL access
          1. Viewing a report
            1. URL access on a native-mode report server
            2. URL access on a SharePoint integrated-mode report server
          2. Using URL access parameters
            1. Report parameters
            2. HTML Viewer commands
            3. Report Viewer commands
            4. Report Server commands
        2. Using the ReportViewer control
          1. Reports Application project
          2. Report Wizard
          3. ReportViewer control
          4. ReportViewer properties
          5. ReportViewer application
        3. Accessing a report with the web service
          1. References
          2. Load method
          3. Render method
          4. Solution deployment
    11. A. About the authors
    12. Index
    13. About the Author
    14. Copyright

    Product information

    • Title: Microsoft SQL Server 2012 Reporting Services
    • Author(s): Stacia Misner
    • Release date: April 2013
    • Publisher(s): Microsoft Press
    • ISBN: 9780735670051