Pro SQL Server 2012 Reporting Services

Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft’s enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you’ll want to take...

Descripción completa

Detalles Bibliográficos
Autor principal: McDonald, Brian (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Berkeley, Calif. : Apress 2012.
Edición:3rd ed
Colección:The expert's voice in SQL server Pro SQL Server 2012 reporting services
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629440406719
Tabla de Contenidos:
  • Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Authors; About the Technical Reviewers; Acknowledgments; Introduction; Who This Book Is For; Prerequisites; Downloading the Code; Contacting the Authors; Chapter 1: Introducing the Reporting Services Architecture; Understanding the Benefits of SSRS; SQL Server 2008 R2 and 2012 Reporting Services Enhancements; Report Builder/Data Modeler; SSRS 2012 Integration with Microsoft Office SharePoint; Tablix Report Properties; Enhanced Charting and Report Item Visualizations; Enhanced Performance and Memory Management
  • Embeddable SSRS ControlsHTML Text Formatting; Microsoft Word Rendering; Report Parts; Lookup Functions; Shared Datasets; SSRS and Business Intelligence; Business Intelligence Development Studio and SQL Server Data Tools; SQL Server Management Studio (SSMS); SSRS Architecture; SSRS Databases; The SSRS Report Server; SSRS Web Service Interface; Authentication Layer; The Report Processor; Data Processing; Report Rendering; Scheduling and Delivery; Client Applications; Report Manager; Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDT); Command-Line Utilities
  • Report BuilderCustom Clients; Installing and Configuring; Deploying SSRS Securely; Summary; Chapter 2: Report Authoring: Designing Efficient Queries; Introducing the Sample Relational Database; Introducing the Schema Design; Knowing Your Data: A Quick Trick with a Small Procedure; Introducing Query Design Basics; Creating a Simple Query Graphically; Creating an Advanced Query; Testing Performance with SQL Server Management Studio (SSMS); Optimizing Performance: Dividing the Load; Using a Parameterized Stored Procedure; Using ISNULL to Evaluate the Parameters; Query Performance anh Indexs
  • Column and Table AliasingTesting the Procedure; Summary; Chapter 3: Introduction to Reporting Services Design with SQL Server Data Tools; Exploring the Elements of BIDS; Setting Up a Basic IDE; Understanding Report Definition Language (RDL); Adding a Report; Setting Up Data Sources and Datasets; Creating a Data Source; Creating a Dataset; Creating Other Data Sources; Configuring Parameters; Setting up Filters; Expressions; Summary; Chapter 4: Laying Out a Report; Setting Up Pagination; Using Report Objects; Implementing a List; Implementing a Textbox; Implementing a Table
  • Implementing a RectangleImplementing a Matrix; Summary; Chapter 5: Implementing Dashboard-Style Report Objects; Understanding the Chart Data Region; Implementing an Image; Implementing a Gauge; Implementing a Map; Implementing a Data Bar; Implementing a Sparkline; Implementing an Indicator; Summary; Chapter 6: Building Reports; Creating a Report with the Report Wizard; Building Reports from Scratch; Formatting the Output; Adding Subtotals; Adding Interactivity; Document Mapping; Visibility; Interactive Sorting; Hyperlink Actions; Adding a Bookmark Link; Adding a URL Link
  • Building the URL Link with a Report Parameter