Learning SQL Server Reporting Services 2012

For a newcomer to SQL Reporting Services 2012, things can seem a bit daunting, but this book will ease your path to becoming an expert. Clear instructions and screenshots will have you generating reports in no time.

Overview

• Build applications using the latest Microsoft technologies: SSIS 2012, SSDT, WPF, and SharePoint 2010
• Reach out to the cloud and master Windows Azure Reporting Services
• Learn the ins and outs of SQL Server Reporting Services 2012 for Native and SharePoint Integrated modes
• Step-by-step learning, guided by a large number of screenshots in every chapter makes it a simple

In Detail

In the present day information-centric world we live in, the success of an enterprise depends enormously on how its information is generated, handled, and disseminated. With ample screenshots and over 65 hands-on exercises, this book will guide you effortlessly through creating cutting edge reports using SQL Server Reporting Services 2012, native and fully integrated with SharePoint Server 2010 including new features like Power View and Data Alerts.

"Learning SQL Server Reporting Services 2012" will get you started right from installation and then move on to configuration of SQL Server Reporting Services 2012. Start learning right from Chapter 1 and build your skill to create reports using the latest tools and deploy them to the latest servers, both Native and SharePoint. No guessing; you will learn all—Power View, Data Alerts, SQL Azure Reporting,the latest Reporting Services Gadgets, and more.

"Learning SQL Server Reporting Services 2012" is a definitive guide to a step-by-step, metered approach to get a jump start on the latest features in SQL Server Reporting Services.Reporting Services in Microsoft SQL Server 2012 is more tightly integrated not only with the Microsoft Business Stack but also with SharePoint, Windows Azure, and the Visual Studio suite of products, with many new features.

You will install and configure the toolset to work with SSRS 2012 integrated with SharePoint 2010. Using SQL Server Data Tools, you will author reports and deploy. You will learn about security to work with Report Manager and Central Administration in SharePoint. Using Report Builder, you will learn about authoring cutting edge reports. You will create Tabular Models and begin experiencing the thrill of creating Power View Reports.

What you will learn from this book

• Install SQL Server 2012, SharePoint Server 2010, and configure Reporting Services both native and SharePoint Integrated on Windows 7
• Install SSDT and author reports, both local and remote, and deploy them to report servers
• Develop desktop and web applications by using Report Viewer controls
• Author different kinds of reports with the latest gadgets by working with Report Builder
• Manage access to the report server, report scheduling, report delivery, report uploads, and downloads with Report Manager
• Create Tabular Models with SQL Server Analysis Services and deploy them to SSAS Server using SSDT
• Author Power View Reports from your SharePoint Site and export them as Power Point files
• Learn to create Data Driven alerts in SharePoint and monitor them on SQL Agent on SSMS
• Work with SQL Azure Reporting Services using Windows Azure Portal and SSMS
• Write applications in SSIS and WPF to access reports and access native server reports from SharePoint Site

對於初次接觸 SQL Reporting Services 2012 的新手來說，可能會感到有些困惑，但這本書將幫助您輕鬆成為專家。清晰的指示和屏幕截圖將讓您立即生成報告。

概述
- 使用最新的 Microsoft 技術構建應用程序：SSIS 2012、SSDT、WPF 和 SharePoint 2010
- 運用雲端技術，掌握 Windows Azure Reporting Services
- 學習 SQL Server Reporting Services 2012 的基礎知識，包括本機模式和 SharePoint 集成模式
- 每章節都有大量屏幕截圖的逐步學習，使學習變得簡單

詳細內容
在我們生活的這個以信息為中心的時代，企業的成功在很大程度上取決於其信息的生成、處理和傳播方式。本書通過豐富的屏幕截圖和超過65個實踐練習，輕鬆指導您使用 SQL Server Reporting Services 2012 創建尖端報告，包括與 SharePoint Server 2010 完全集成的新功能，如 Power View 和數據警報。

《學習 SQL Server Reporting Services 2012》將從安裝開始，然後進行 SQL Server Reporting Services 2012 的配置。從第1章開始學習，使用最新的工具創建報告並部署到最新的本機和 SharePoint 服務器。您將學習所有內容，包括 Power View、數據警報、SQL Azure Reporting，最新的 Reporting Services 小工具等等。

《學習 SQL Server Reporting Services 2012》是一本關於 SQL Server Reporting Services 最新功能的逐步、有節奏的指南。Microsoft SQL Server 2012 中的 Reporting Services 不僅與 Microsoft 商業堆棧緊密集成，還與 SharePoint、Windows Azure 和 Visual Studio 產品套件緊密集成，帶來了許多新功能。

您將安裝和配置工具集，以便在與 SharePoint 2010 集成的 SSRS 2012 上工作。使用 SQL Server Data Tools，您將編寫報告並進行部署。您將學習有關在 Report Manager 和 SharePoint 的 Central Administration 中使用安全性的工作。使用 Report Builder，您將學習創建尖端報告。您將創建 Tabular Models，並開始體驗創建 Power View 報告的樂趣。

本書將教您以下內容：
- 在 Windows 7 上安裝 SQL Server 2012、SharePoint Server 2010，並配置本機和 SharePoint 集成的 Reporting Services
- 安裝 SSDT，編寫本地和遠程報告，並將其部署到報告服務器
- 使用 Report Viewer 控件開發桌面和 Web 應用程序
- 通過使用 Report Builder 與最新的小工具一起創建不同類型的報告
- 使用 Report Manager 管理對報告服務器的訪問權限、報告排程、報告傳遞、報告上傳和下載
- 使用 SQL Server Analysis Services 創建 Tabular Models，並使用 SSDT 將其部署到 SSAS 服務器
- 從 SharePoint 網站創建 Power View 報告，並將其導出為 PowerPoint 文件
- 學習在 SharePoint 中創建數據驅動的警報，並在 SSMS 上使用 SQL Agent 監控它們
- 使用 Windows Azure Portal 和 SSMS 使用 SQL Azure Reporting Services
- 使用 SSIS 和 WPF 編寫應用程序，以訪問報告並從 SharePoint 網站訪問本機服務器報告