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...
Autor principal: | |
---|---|
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