Index
A
- Advanced... button / Hands-on exercise 1.3 – configuring SQL Server 2012 Reporting Services in Native mode
- advanced filtering techniques / Advanced filtering
- AlwaysOn Failover Cluster / SQL Server 2012 – mission statement by Microsoft
- AlwaysOn feature / SQL Server 2012 – mission statement by Microsoft
- authentication
- about / Authentication, Authentication types
- RSWindowsNegotiate type / Authentication types
- RSWindowsNTLM type / Authentication types
- RSWindowsKerberos type / Authentication types
- RSWindowsBasic type / Authentication types
- Custom type / Authentication types
- authorization
- about / Authorization
- Content Manager Role / Authorization
- Publisher Role / Authorization
- Browser Role / Authorization
- Report Builder Role / Authorization
- My Reports Role / Authorization
- System Administrator Role / Authorization
- System User Role / Authorization
B
- BI
- about / What is business intelligence?
- BIDS / What is business intelligence?, What is Windows Azure SQL Reporting?
- BISM
- Browse button / Saving a report as report parts
- bubble charts / Scatter and bubble charts
- BUILTIN\Administrators / Assigning RSMax to the RS System Administrator role
- Business Intelligence (BI) / Overview of Reporting Services 2012
C
- @CategoriesCategoryID parameter / Creating the subreport
- card
- about / Displaying data as a card
- CatSales / Saving a report as report parts
- Chart Tools option / Creating a chart showing sales orders from NW Employees shipped from cities
- Cloud service (mysorian) / Hands-on exercise 9.1 – accessing the Windows Azure portal
- collation / Installation steps
- configuration file modifications, in native mode
- about / Hands-on exercise 3.1 – modifying the configuration file in Native mode
- Report Server Web service, on/off actions / Turn on/off the Report Server Web Service
- scheduled events, on/off actions / Turn on/off the scheduled events and delivery
- Report Manager, on/off action / Turn on/off the Report Manager
- Connect to Report Server window / Reusing the report parts items , Hands-on exercise 7.1 – creating a report in Report Builder and saving it to the SharePoint site
- custom code
- incorporating, into reports / Incorporating custom code into reports, Hands-on 8.11 – inserting custom code into a report
D
- data
- highlighting / Highlighting of data
- displaying, as card / Displaying data as a card
- data-driven report subscription
- creating / Hands-on exercise 4.12 – creating data-driven report subscription for delivery to a file share, Creating the data-driven Subscription and testing it
- Subscribers database, creating in SQL Server / Create a Subscribers database in SQL Server
- table, populating in Subscribers database / Populate a table in the Subscribers database
- data alert
- creating / Creating a Data Alert
- creating, in Data Alert Designer / Hands-on exercise 7.3 – creating Data Alert in Data Alert Designer
- editing / Editing Data Alerts
- Data Alert Designer
- data alert, creating / Hands-on exercise 7.3 – creating Data Alert in Data Alert Designer
- data alerts
- starting with / Getting ready for Data Alerts
- working with, permission grant / Granting permissions to work with Data Alerts
- Data Alerts. Power View / Overview of Reporting Services 2012
- Data Manager window / Hands-on exercise 7.3 – creating Data Alert in Data Alert Designer
- data source
- creating, model as source used / Creating a data source using the model as the source
- Data Source Properties page / Hands-on exercise 5.2 – creating a report from a shared data source, Hands-on exercise 5.11 – creating reports with embedded maps
- DAX / Getting tables from the database
- default field set / Default field set and table behavior
- Distributed Replay tool / SQL Server 2012 – mission statement by Microsoft
- document map
- adding, to report / Adding a Document Map to the report
- drill-down report
- about / Drill-down report
- creating / Hands-on exercise 5.6 – Creating a drill-down report
- drill-through reports
- about / Drill-through reports
- drill through report
- creating / Hands-on exercise 5.5 – Creating a drill-through report
- source report / Source report
- destination report / Destination report
- action, setting up / Set up the drill-through action
- DSP / URL access
- DSU / URL access
E
- Edit Data Alert window / Editing Data Alerts
- Edit Role Assignment page / Hands-on exercise 4.4 – creating a permission to a specific report
- ErrorLevel property / Report validation
F
- features, Reporting Services 2012
- about / Salient features of Reporting Services 2012
- report definition / Report definition
- report part reusability / Report parts and their reusability
- report customization / Customizing reports
- report, saving / Saving and deploying reports
- report, deploying / Saving and deploying reports
- report validation / Report validation
- reports, viewing / Viewing reports
- reports, managing / Managing reports
- RS2012 SharePoint Integrated / Features new in RS2012 SharePoint Integrated
- security implementation / Implementing security – authentication and authorization
- URL access / URL access
- Reporting Services extensions / Reporting Services extensions
- Reporting Services tools / Reporting Services tools
- Report Server administration tools / Tools for Report Server administration
- report authoring tools / Tools for report authoring
- report content management tools / Tools for report content management
- Feature Selection page / Installation steps
- files, downloading, from Report Server to file system
- about / Uploading and downloading files from the Report Server to the filesystem
- on computer / Uploading a report on the computer to the Report Server
- steps / Hands-on exercise 4.8 – uploading a report to the Report Server
- report definition file, downloading / Hands-on exercise 4.9 – downloading and reviewing a report definition file from the Report Server
- report definition file, reviewing / Hands-on exercise 4.9 – downloading and reviewing a report definition file from the Report Server
- Find tool / Viewing, searching, and printing reports
- folder
- creating / Hands-on exercise 4.1 – creating, modifying, moving, and deleting folders, Creating a folder and a subfolder
- deleting / Hands-on exercise 4.1 – creating, modifying, moving, and deleting folders
- navigating / Navigating through the folders
- subfolder, creating / Creating a folder and a subfolder
- item, moving into / Moving an item into a folder
- foreign key / Drill-down report
- FromSSDT-OrderDetails report / Hands-on exercise 4.9 – downloading and reviewing a report definition file from the Report Server
G
- Getting Started screen / Creating the main report
- GIS / Managing reports
- group
- setting up / Hands-on exercise 5.4 – setting up a group and creating a document map
- adding, to data / Adding a group to the data
- Group Properties windows / Configuring page breaks
H
- hardware
- configuration / Configuring the hardware used for the book
- hardware requirements
- hard disk space requirement / Hardware requirements
- data file storage / Hardware requirements
- DVD drive / Hardware requirements
- monitor and pointing device / Hardware requirements
- pocessor speed / Hardware requirements
- memory / Hardware requirements
- processor type for a 64-bit processor / Hardware requirements
- HighTemp indicators / Hands-on exercise 5.10 – creating reports using indicators
- Home page / Accessing the Web parts
- HTTP Connection Manager Editor window / Hands-on exercise 10.1 – accessing the Native mode Report Server using SSIS
I
- indicators
- about / Indicators
- used, for report creation / Hands-on exercise 5.10 – creating reports using indicators
- item-level roles / User access to Report Server (Report Manager)
- ITEMS menu / Hands-on exercise 9.3 – using the Windows Azure SQL Reporting Services to create folders, share data sources, and upload reports
K
- KPI / Adding measures
L
- linked reports
- about / Linked reports
- creating / Hands-on exercise 5.7 – creating linked reports
- creating, in France folder / Customizing the linked report in the France folder
- Local Mode / Software and hardware requirements
M
- MainWindow.xaml / Hands-on exercise 10.2 – accessing Report Server URLs in a WPF project
- Management Endpoints / Report Server Web Services API
- Manage Report History / Snapshot and snapshot history
- Manage Reporting Services Application page / Creating the Reporting Services Service application
- master database / Granting permissions to work with Data Alerts
- measures
- about / Adding measures
- adding / Adding measures
- Microsoft Report Viewer Runtime
- about / Microsoft Report Viewer Runtime
- 2008 / Microsoft Report Viewer Runtime
- 2010 / Microsoft Report Viewer Runtime
- 2010 SP1 / Microsoft Report Viewer Runtime
- 2012 / Microsoft Report Viewer Runtime
- Microsoft SQL Server Data Tools-Database projects / Introduction to SQL Server Data Tools
- model
- deploying / Deploying the model
- MSDN / SQL Server 2012 Reporting Services – Known Issues
N
- Native mode installation
- major components / Native mode
- Native mode Reporting Services
- exploring / Hands-on exercise 8.8 – exploring Native mode Reporting Services
- Native mode report server / The Native mode Report Server
- server configuration / Native mode Report Server configuration
- Windows Forms ReportViewer, supported extensions / Extensions supported on a Windows Forms ReportViewer
- Windows Management Instrumentation / Windows Management Instrumentation
- Native mode report server
- about / URL access, Hands-on exercise 8.1 – URL access, Native mode Report Server
- actions / URL access
- report server, accessing / Accessing the Report Server
- folder contents, listing / Listing contents of a folder
- report part component, accessing / Accessing a component in report parts
- report, rendering / Rendering a report
- data source content, accessing / Accessing the contents of a data source
- supported formats, exporting / Exporting to supported formats
- report rendering, with report parameter / Rendering a report with the report parameter
- Native mode Report Server
- exploring / Hands-on exercise 8.9 – exploring the Native mode Report Server programmatically
- access permission, to WMI / Providing access permission to WMI
- accessing, SSIS used / Hands-on exercise 10.1 – accessing the Native mode Report Server using SSIS
- Native mode Report Server access
- Report Server web service WSDL file, creating / Creating the Report Server Web Service WSDL file
- WSDL file, providing to Web Service Task / Providing the WSDL file to the Web Service Task
- File System Task, adding to Control Flow page / Adding a File System Task to the Control Flow page
- Native Report Server reports
- accessing, from SharePoint web parts / Accessing Native Report Server reports from SharePoint Web parts
- report viewing, SharePoint web parts used / Hands-on exercise 10.3 – viewing reports on the Native mode Report Server using SharePoint Web parts
- Navigate () method / Hands-on exercise 10.2 – accessing Report Server URLs in a WPF project
- New Role Assignment page / Assigning users to item-level roles
O
- Office Open XML / Report Builder 3.0 user interface
- Operating System (OS) / Creating a Windows user
- operating system requirements (64-bit) / Operating system requirements (64-bit)
P
- parameter
- parameterized reports
- about / Parameterized reports
- permission
- updating, ways / Granting permissions to work with Data Alerts
- granting, to report / Giving permission to a report
- PowerShell
- using, for log file review / Using PowerShell to review the logfile
- about / PowerShell
- basic review / Hands-on exercise 8.6 – a quick review of basics
- reporting services, with SharePoint Integration / PowerShell and reporting services with SharePoint Integration
- reporting services , exploring in SharePoint Integrated mode / Hands-on exercise 8.7 – exploring reporting services in SharePoint Integrated mode
- and Native mode Reporting Services 2010 / PowerShell and Native mode Reporting Services 2010
- Native mode Report Server, exploring / Hands-on exercise 8.9 – exploring the Native mode Report Server programmatically
- Report Server properties, WMI used / Report Server properties using WMI
- Power View
- about / What is Power View?
- resources / Helpful resources
- development environment, points / What do you need to author a Power View report?
- creating / Creating a Power View
- model, connecting to / Connecting to the model
- data source creation, using model as source / Creating a data source using the model as the source
- report creation, data source used / Creating a Power View report using the data source
- report, exploring / Hands-on exercise 6.5 – exploring a Power View report
- Power View report
- authoring, need for / What do you need to author a Power View report?
- exploring / Hands-on exercise 6.5 – exploring a Power View report
- first view, creating / Creating the first view of the Power View report
- sales order shipped chart, modifying / Creating a chart showing sales orders from NW Employees shipped from cities
- second view, adding / Adding a second view to the Power View report
- data, highlighting / Highlighting of data
- data, displaying as card / Displaying data as a card
- tiles, using / Using tiles
- data, slicing / Slicing the data
- advanced filtering techniques / Advanced filtering
- scatter chart / Scatter and bubble charts
- bubble chart / Scatter and bubble charts
- animation / Animation with Power View
- views, navigating / Navigating through the views of the Power View report
- save button / Save, do, undo, and refresh
- undo button / Save, do, undo, and refresh
- refresh button / Save, do, undo, and refresh
- saving, to Saving to PowerPoint / Saving to PowerPoint
- primary key / Drill-down report
- programming interfaces
- Project RSPW2012
- Publish Report Parts window / Saving a report as report parts
R
- RDLC
- converting, to RDL file / Hands-on exercise 2.8 – converting an RDLC to a RDL file
- Reading Mode / Saving to PowerPoint
- Remote Mode / Software and hardware requirements
- Remove Field / Creating the first view of the Power View report
- report
- creating, Report Server Project Wizard used / Hands-on exercise 2.1 – creating a report using the Report Server Project Wizard
- deploying, to Report Server / Hands-on exercise 2.2 – deploying the report to the Report Server
- creating, SSDT Report wizard used / Hands-on exercise 2.3 – creating a report using the Report wizard in SSDT
- modifying, in Project RSPW2012 / Hands-on exercise 2.4 – modifying the report in Project RSPW2012 using an expression
- formats, in Report Server Reports / Report formats supported in Report Server Reports
- creating, Visual Studio 2012 used / Creating reports using Visual Studio 2012
- defining / Report definition
- creating / Creating reports, Creating a report and saving to the Report Server
- data / Report data
- new toolbox items, in Report Builder 3 / New toolbox items in Report Builder 3
- customizing / Customizing reports
- deploying / Saving and deploying reports
- saving / Saving and deploying reports
- validating / Report validation
- viewing / Viewing reports
- managing / Managing reports
- deploying, step / First step – deploying reports
- creating, embedded data source used / Hands-on exercise 5.1 – creating a report with an embedded data source
- creating, from shared data source / Hands-on exercise 5.2 – creating a report from a shared data source
- List report, creating / Creating a List report
- subreport / Hands-on exercise 5.3 – creating a report that has a subreport
- main report, creating / Creating the main report
- freeform report, adding / Adding a freeform report (List)
- subreport, embedding / Embedding the subreport in the main report
- groups / Report with groups
- bringing up / Bring up the report from the previous hands-on exercise and remove a parameter
- document map, adding / Adding a Document Map to the report
- page breaks, configuring / Configuring page breaks
- interactive sorting, adding / Adding interactive sorting
- drill-through reports / Drill-through reports
- drill-down report / Drill-down report
- creating, XML data sources used / Creating a report with XML data sources
- saving, as report parts / Saving a report as report parts
- saving, as reort parts / Saving a report as report parts
- saving, to Report Server / Creating a report and saving to the Report Server
- creating, in Report Builder / Creating a report in Report Builder and saving it to the Documents library, Hands-on exercise 7.1 – creating a report in Report Builder and saving it to the SharePoint site
- saving, to Documents library / Creating a report in Report Builder and saving it to the Documents library
- saving, to SharePoint site / Hands-on exercise 7.1 – creating a report in Report Builder and saving it to the SharePoint site
- permissions, granting / Giving permission to a report
- control, granting to user / Hands-on exercise 7.2 – giving full control of a report to a user
- creating, SSDT used / Hands-on exercise 9.2 – creating a report using SSDT and deploying it to the Windows Azure Reporting on the Cloud
- table, creating for / Creating a table for the report
- viewing, on SQL Reporting web server / Viewing the report on the SQL Reporting Web server
- report, creating for Windows Form application
- Report Viewer Control, using / Hands-on exercise 2.5 – creating a report for a Windows Form application using Report Viewer Control
- report-related projects
- in Visual Studio 2012 / Report-related projects in Visual Studio 2012
- report authoring / Report authoring
- key considerations / Report authoring
- report authoring, tools
- Report Designer / Tools for report authoring
- Report Builder / Tools for report authoring
- SharePoint Site for Power View / Tools for report authoring
- Report Builder
- report authoring / Report authoring with Report Builder
- report authoring / Report authoring with Report Builder
- installing / Downloading and installing Report Builder
- downloading / Downloading and installing Report Builder
- standalone version, files / Downloading and installing Report Builder
- user interface / Report Builder 3.0 user interface
- report, creating / Creating a report in Report Builder and saving it to the Documents library
- using, for report viewing / Using Report Builder to view reports
- report changes, making / Making changes to the report and placing it on the Report Server
- Report Builder 3
- enhancements / Overview of Reporting Services 2012
- Report Builder installation
- requirements / Downloading and installing Report Builder
- report caching
- about / Report caching
- report processing options / Report processing options
- refresh options / Cache refresh options
- cache refresh plan, creating / Hands-on exercise 4.13 – creating a cache refresh plan by preloading the cache
- report content
- creating / Creating content for reports and viewing them
- author reports, preparing / Preparing to author reports
- report content management, tools
- Report Server Web Service / Tools for report content management
- Report Manager / Tools for report content management
- RS Utility-RS Server Command Prompt / Tools for report content management
- report creation, Visual Studio 2012 used
- software requirements / Software and hardware requirements
- hardware requirements / Software and hardware requirements
- Web Report Viewer Control, using / Hands-on exercise 2.6 – creating a report using Report Viewer Control for the Web
- Report Viewer Control, using in remote mode / Hands-on exercise 2.7 – using Report Viewer Control in the remote mode
- RDLC, converting to RDl FILE / Hands-on exercise 2.8 – converting an RDLC to a RDL file
- report creation, XML data sources used
- about / Creating a report with XML data sources
- well-formed XML data, creating / Creating well-formed XML data
- data display, with sparklines / Displaying data with sparklines, maps, data bars, and indicators
- data display, with maps / Displaying data with sparklines, maps, data bars, and indicators
- data display, with data bars / Displaying data with sparklines, maps, data bars, and indicators
- data display, with indicators / Displaying data with sparklines, maps, data bars, and indicators
- data highlighting, with data bars / Hands-on exercise 5.8 – creating a report and highlighting data with data bars
- data displaying, sparklines used / Displaying data with sparklines
- sparklines, using / Creating a table
- sparklines, inserting / Creating a report and inserting sparklines
- Report Dashboard
- managing / Managing the report Dashboard
- Report Data pane / Report Server Project Wizard
- Report data sources
- about / Report data sources
- embedded data source / An embedded data source
- shared data source / A shared data source
- report definition
- XML-based report definition (.rdl file) / XML-based report definition (the .rdl file)
- Power View report contents / Power View report contents
- Report Explorer / Accessing Native Report Server reports from SharePoint Web parts
- Reporting Service, in SSM
- turning on/off / Hands-on exercise 3.2 – turn the Reporting Service on/off in SSMS
- Reporting Services
- extensions / Reporting Services extensions
- tools / Reporting Services tools
- Reporting Services (RS) / BI Projects on SSDT, Getting ready for Data Alerts
- reporting services, in SharePoint Integrated mode
- about / Hands-on exercise 8.7 – exploring reporting services in SharePoint Integrated mode
- application server / Application server of the Reporting Services Service Application
- Reporting Services SharePoint Integration related cmdlets / Finding all cmdlets related to Reporting Services SharePoint Integration
- report server, proxy URL / Proxy URL of the Report Server
- SP service application pool / SP service application pool
- Reporting Services 2012
- installing, in SharePoint Integrated mode / Installing Reporting Services 2012 in SharePoint Integrated mode
- features / Salient features of Reporting Services 2012
- Reporting Services 2012 installation, in SharePoint Integrated mode
- types / Installing Reporting Services 2012 in SharePoint Integrated mode
- Reporting Services Add-in / Reporting Services add-in for SharePoint 2010
- SharePoint Service, installing / Installing and starting the Reporting Services SharePoint Service
- Reporting Services command prompt utilities
- about / Reporting Services command prompt utilities
- RSS utility / The RSS utility
- rs.exe / What can rs.exe do?
- data source creating, rs.exe used / Hands-on exercise 8.10 – creating a data source on the Report Server using rs.exe and a script file
- Rskeymgmt utility / The Rskeymgmt utility
- Rsconfig / Rsconfig
- Reporting Services Configuration
- about / Reporting Services configuration
- native mode / Native mode
- SharePoint Integrated mode / SharePoint Integrated mode
- configuration file, modifying in native mode / Hands-on exercise 3.1 – modifying the configuration file in Native mode
- Reporting Service, turning on/off / Hands-on exercise 3.2 – turn the Reporting Service on/off in SSMS
- Reporting Services extensions
- tasks / Reporting Services extensions
- types / Reporting Services extensions
- Reporting Services Service application
- Reporting Services SharePoint Service
- installing / Hands-on exercise 1.4 – installing the Reporting Services SharePoint Service
- Reporting Services Service application, creating / Creating the Reporting Services Service application
- Power View Site Collection feature, activating / Activating the Power View site collection feature
- Reporting Services SharePoint Service installation
- about / Hands-on exercise 1.4 – installing the Reporting Services SharePoint Service
- service, starting / Starting the service
- Reporting Services tools / Tools for Report Server administration
- report management
- report scheduling / Report scheduling
- subscriptions / Subscriptions and delivery
- delivery / Subscriptions and delivery
- subscriptions, requirements / Subscriptions and delivery
- delivery Extension / Subscriptions and delivery
- Report Manager
- tasks, performing / Tasks performed using Report Manager
- starting / Starting Report Manager
- starting, for URL / Starting Report Manager for the URL
- user access / User access to Report Server (Report Manager)
- user interface / Report Manager user interface
- customizing / Customizing Report Manager
- permissions, configuring from / Configuring permissions from Report Manager
- users, assigning to Item-Level roles / Assigning users to item-level roles
- users, reviewing on reporting services database / Review users on a Reporting Services database
- user, assigning to custom role / Hands-on exercise 4.3 – assigning a user to a Custom role
- permission, creating to specific report / Hands-on exercise 4.4 – creating a permission to a specific report
- Report Manager user interface
- about / Report Manager user interface
- customizing / Report Manager user interface
- folders, modifying / Hands-on exercise 4.1 – creating, modifying, moving, and deleting folders
- folders, creating / Hands-on exercise 4.1 – creating, modifying, moving, and deleting folders
- folders, moving / Hands-on exercise 4.1 – creating, modifying, moving, and deleting folders
- folders, deleting / Hands-on exercise 4.1 – creating, modifying, moving, and deleting folders
- role based security, configuring / Configuring role-based security
- Windows user, assigning to System Administrator role / Hands-on exercise 4.2 – assigning a Windows user to the System Administrator role
- Report Part Gallery / Reusing the report parts items
- report parts
- about / Report parts and their reusability, Report parts
- reusing / Report parts and their reusability
- creating / Hands-on exercise 5.12 – creating report parts and reusing an item
- items, reusing / Reusing the report parts items
- reports
- viewing / Viewing, searching, and printing reports, Viewing reports
- searching / Viewing, searching, and printing reports
- printing / Viewing, searching, and printing reports, Printing reports
- format, changing / Printing reports, Change the report format
- data feed format / Data feed format
- creating, indicators used / Hands-on exercise 5.10 – creating reports using indicators
- maps, using / Reports with maps
- creating, with embedded maps / Hands-on exercise 5.11 – creating reports with embedded maps
- parts / Report parts
- managing / Managing reports
- Report Server
- report, deploying to / Hands-on exercise 2.2 – deploying the report to the Report Server
- report, saving to / Creating a report and saving to the Report Server
- report, running / Accessing the server and running a report
- accessing / Accessing the server and running a report
- indicator / Do gadgets like indicators and data bars work?
- data bar / Do gadgets like indicators and data bars work?
- SQL Server 2012 Reporting Services / SQL Server 2012 Reporting Services – Known Issues
- Report Server administration, tools
- Reporting Services Configuration Manager / Tools for Report Server administration
- SQL Server Management Studio / Tools for Report Server administration
- SQL Server Configuration Manager / Tools for Report Server administration
- RSConfig Command line Utility / Tools for Report Server administration
- Rskeymgmt Utility / Tools for Report Server administration
- Windows Management Instrumentation (WMI) Classes / Tools for Report Server administration
- Report Server Catalog / Report Server – configuration options
- Report Server Project Wizard
- used, for report creating / Hands-on exercise 2.1 – creating a report using the Report Server Project Wizard
- Report Server Web Services API
- about / Report Server Web Services API
- report, rendering on native mode report server / Hands-on exercise 8.4 – rendering a report on the Native mode Report Server into different formats
- SharePoint Integrated mode / Reporting Services in SharePoint Integrated mode
- SharePoint management endpoints, accessing / Hands-on exercise 8.5 – accessing SharePoint management endpoints
- Report subscription
- about / Report subscription and delivery
- defining / Report subscription and delivery
- standard, types / Report subscription and delivery
- Data Driven, types / Report subscription and delivery
- delivering, types / Report subscription and delivery
- event driven report subscription, creating / Hands-on exercise 4.10 – creating an event-driven report subscription for delivery by an e-mail, Hands-on exercise 4.11 – creating an event-driven report subscription for delivery to a file share
- data driven report subscription, creating / Hands-on exercise 4.12 – creating data-driven report subscription for delivery to a file share
- Report Viewer / Accessing Native Report Server reports from SharePoint Web parts
- Report Viewer Control
- used, for Windows Form application report creation / Hands-on exercise 2.5 – creating a report for a Windows Form application using Report Viewer Control
- used, for Web report creating / Hands-on exercise 2.6 – creating a report using Report Viewer Control for the Web
- using, in Remote mode / Hands-on exercise 2.7 – using Report Viewer Control in the remote mode
- ReportViewer control
- about / ReportViewer control
- using with URL access and web applications / Hands-on exercise 8.3 – using URL access and ReportViewer controls with Web applications
- Report wizard
- used, for report creation in SSDT / Hands-on exercise 2.3 – creating a report using the Report wizard in SSDT
- roles, tabular model
- administrator / Tabular model permissions
- process / Tabular model permissions
- Read and Process / Tabular model permissions
- read / Tabular model permissions
- none / Hands-on exercise 6.3 – creating a role in SQL Server Data Tools
- rs.exe
- tasks / What can rs.exe do?
- RS2012
- RS2012 SharePoint Integrated
- features / Features new in RS2012 SharePoint Integrated
- Power View / Power View
- Data Alerts / Data Alerts
- Rsconfig / Rsconfig
- Rskeymgmt utility / The Rskeymgmt utility
- RSS utility / The RSS utility
S
- SAAS / What do you need to author a Power View report?
- sample databases installation
- about / Installing sample databases
- files, downloading / Downloading files and running scripts
- scripts, running / Downloading files and running scripts
- scatter charts / Scatter and bubble charts
- search feature
- about / Search
- using, within Report Manager site / Searching the Report Manager site
- using, within report / Search within a report
- Search icon / Reusing the report parts items
- security implementation
- about / Implementing security – authentication and authorization
- authentication / Authentication
- authentication, types / Authentication types
- authorization / Authorization
- Service Applications page / Creating the Reporting Services Service application
- Service Principal Name / Report Server – configuration options
- Service Reference Settings page / Hands-on exercise 8.4 – rendering a report on the Native mode Report Server into different formats
- Setup Support Rules page / Installation steps
- shared data source
- about / A shared data source
- creating, on Report Manager / Hands-on exercise 4.5 – creating a shared data source on Report Manager
- data model, creating from data source / Hands-on exercise 4.6 – creating a data model from a data source
- SharePoint environment
- overview / Structural design of SQL servers and SharePoint environment
- SharePoint Integrated mode / SharePoint Integrated mode
- SharePoint Integrated mode
- about / SharePoint Integrated mode
- elements / SharePoint Integrated mode
- diagram explanation / SharePoint Integrated mode
- reporting services, exploring / Getting help about help
- SharePoint Integrated mode report server
- about / Hands-on exercise 8.2 – URL access and SharePoint Integrated mode Report Server
- accessing, in SP-integrated implementation / Accessing the Report Server in SP-integrated implementation, Accessing a report on the Report Server in SP-integrated implementation
- SharePoint management endpoints
- SharePoint Server 2010
- model, connecting from / Hands-on exercise 6.4 – connecting to the model from SharePoint Server 2010
- SharePoint Server 2010 Enterprise Edition
- SharePoint site
- SharePoint web parts
- Native Report Server reports, accessing / Accessing Native Report Server reports from SharePoint Web parts
- used, for Native Report Server reports view / Hands-on exercise 10.3 – viewing reports on the Native mode Report Server using SharePoint Web parts
- accessing / Accessing the Web parts
- Show Filters icon / Creating the first view of the Power View report
- Skyblue database based report
- creating, on Windows Azure / Creating a report based on the Skyblue database on the Windows Azure Platform
- Slicer / Using tiles
- SMTP / Hands-on exercise 1.3 – configuring SQL Server 2012 Reporting Services in Native mode
- snapshot
- about / Snapshot and snapshot history
- history / Snapshot and snapshot history
- creating / Hands-on exercise 4.14 – creating a snapshot and snapshot history
- history, creating / Hands-on exercise 4.14 – creating a snapshot and snapshot history
- Snapshot Options
- history, creating / Hands-on exercise 4.14 – creating a snapshot and snapshot history
- software installation
- software requirements / Software requirements
- SQL database
- creating, on Windows Azure / Creating a SQL database on Windows Azure
- SQL database service (Aloha-HNL) / Hands-on exercise 9.1 – accessing the Windows Azure portal
- SQL Reporting web server
- report, viewing / Viewing the report on the SQL Reporting Web server
- SQL Server
- Native mode installation / Structural design of SQL servers and SharePoint environment
- SQL Server 2012
- highlights / SQL Server 2012 – mission statement by Microsoft
- SQL Server 2012 installation
- requirements / SQL Server 2012 installation requirements
- source file, downloading / Downloading the source file
- steps / Installation steps
- verifying / Hands-on exercise 1.2 – verifying the installation
- SQL Server 2012 installation, requirements
- operating system requirements (64-bit) / Operating system requirements (64-bit)
- hardware requirements / Hardware requirements
- software requirements / Software requirements
- SQL Server 2012 installation verification
- SQL Server 2012 Reporting Services / SQL Server 2012 Reporting Services – Known Issues
- SQL Server 2012 Reporting Services Native mode
- configuring / Hands-on exercise 1.3 – configuring SQL Server 2012 Reporting Services in Native mode
- Report Server, configuration options / Report Server – configuration options
- SQL Server Reporting Services
- configuring / Configuring SQL Server Reporting Services
- SQL Server Reporting Services Application / Creating the Reporting Services Service application
- SQL servers structural design
- SSDT / Overview of Reporting Services 2012, What is business intelligence?, What is Windows Azure SQL Reporting?, Hands-on exercise 10.1 – accessing the Native mode Report Server using SSIS
- about / Introduction to SQL Server Data Tools
- BI Projects / BI Projects on SSDT
- Report Server Project / Report Server Project
- Report Server Project Wizard / Report Server Project Wizard
- used, for report creating / Creating reports using SSDT
- SSDT ribbon
- review / Brief review of an SSDT ribbon
- SSIS
- used, for Native mode Report Server access / Hands-on exercise 10.1 – accessing the Native mode Report Server using SSIS
- SSMS
- about / Turn on/off the scheduled events and delivery
- Reporting Service, turning on/off / Hands-on exercise 3.2 – turn the Reporting Service on/off in SSMS
- table, populating / Populating the table in SSMS
- SSRS
- about / Overview of Reporting Services 2012
- overview / Overview of Reporting Services 2012
- enhancements / Overview of Reporting Services 2012
- data sources / Overview of Reporting Services 2012
- subreport
- about / Subreports
- creating / Creating the subreport
- alternate row background color, setting / Making background-color of alternate rows different
- Subscriptions page / Hands-on exercise 4.10 – creating an event-driven report subscription for delivery by an e-mail
- system-level roles / User access to Report Server (Report Manager)
T
- table
- populating, in SSMS / Populating the table in SSMS
- table behavior / Default field set and table behavior
- tabular model
- about / Creating a tabular model
- creating / Hands-on exercise 6.1 – creating a tabular model
- SSDT ribbon review / Brief review of an SSDT ribbon
- connecting, to Northwind database / Creating a connection to the Northwind database
- tables, obtaining from database / Getting tables from the database
- default field set / Default field set and table behavior
- table behavior / Default field set and table behavior
- measures, adding / Adding measures
- deploying / Deploying the model, Hands-on exercise 6.2 – deploying the model
- permissions / Tabular model permissions
- roles / Tabular model permissions
- TargetServerURL / Deploying the report to the SQL Reporting Services on Windows Azure
- TECHNET / SQL Server 2012 Reporting Services – Known Issues
- TestSP link / Editing Data Alerts
- tiles
- using / Using tiles
- troubleshooting
- about / Troubleshooting
- PowerShell used, for log file review / Using PowerShell to review the logfile
- alert logs / Alert logs and alerting database
- database alerting / Alert logs and alerting database
U
- ULS
- about / Troubleshooting
- URL access
- about / URL access
- user access, Report Manager
- system-level roles / User access to Report Server (Report Manager)
- item-level roles / User access to Report Server (Report Manager)
- granting, considerations / Considerations for giving user access to the Report Server
- user interface, Report Builder
- users
- managing / Managing users
- utilities
V
- View Report / Viewing the report on the SQL Reporting Web server
- View Report History / Hands-on exercise 4.14 – creating a snapshot and snapshot history
- Visibility property / Hands-on exercise 5.6 – Creating a drill-down report
- Visual Studio 2012
- report-related projects / Report-related projects in Visual Studio 2012
- used, for report creation / Creating reports using Visual Studio 2012
- Visual Studio 2012 (VS2012) / What is business intelligence?
W
- WASR
- Web Services URL
- Windows Azure
- SQL database, creating / Creating a SQL database on Windows Azure
- SQL Reporting Service, creating / Creating a SQL Reporting Service in Windows Azure
- report, deploying to SQL Reporting Services / Deploying the report to the SQL Reporting Services on Windows Azure
- Windows Azure HDInsight / Creating a connection to the Northwind database
- Windows Azure Platform
- Skyblue database based report, creating / Creating a report based on the Skyblue database on the Windows Azure Platform
- Windows Azure SQL Database
- table, migrating to on-premise SQL Server 2012 / Hands-on exercise 9.4 – migrating a table on an on-premise SQL Server 2012 to the Windows Azure SQL database
- Windows Azure SQL Reporting
- about / What is Windows Azure SQL Reporting?
- limitations / What is Windows Azure SQL Reporting?
- portal, accessing / Hands-on exercise 9.1 – accessing the Windows Azure portal
- Windows Azure SQL Reporting Services
- menu items / Hands-on exercise 9.3 – using the Windows Azure SQL Reporting Services to create folders, share data sources, and upload reports
- ITEMS menu / Hands-on exercise 9.3 – using the Windows Azure SQL Reporting Services to create folders, share data sources, and upload reports
- shared data source, creating / Creating a shared data source in the portal
- reports, managing / Managing your reports and users is easy, Managing reports
- users, managing / Managing users
- Report Dashboard, managing / Managing the report Dashboard
- activity status / Status of activities
- permission, managing / Managing permissions
- reports, viewing / Report viewing
- Windows Presentation Foundations classes project
- reports, accessing / Accessing reports from a Windows Presentation Foundations classes project
- Report Server URLs, accessing in WPF project / Hands-on exercise 10.2 – accessing Report Server URLs in a WPF project
- Windows user
- creating / Creating a Windows user
- RSMax, assigning to RS System Administrator role / Assigning RSMax to the RS System Administrator role
- WMI
- about / PowerShell and Native mode Reporting Services 2010
- used, for Report Server properties / Report Server properties using WMI
- WSDL
X
- XML / Accessing reports from a Windows Presentation Foundations classes project
- XML data sources
- used, for report creating / Creating a report with XML data sources