|
The Big Picture
SQL Server Reporting Services Features | The Reporting Services Key Components | Client Components | Web Components | Report Server Components | Database Components | Report Design Options | Visual Studio and Development Studio | Data Processing Extensions | Included Extensions | Custom Data Processing Extensions | Deployment Options | Key Considerations | Distribution Options | Rendering Extensions
The Reporting Wizard
Starting SQL Server Business Intelligence Development Studio | Creating a New Report Project | Welcome to the Report Wizard Dialog | Select the Data Source Dialog | Design the Query Dialog | Select the Report Type Dialog | Design the Table or Design the Matrix Dialog | Choose the Table Layout | Choose Table Style or Matrix Style Dialog | Completing the Wizard Dialog | Understanding What Just Happened | Previewing Reports | Publishing Reports | Accessing Reports via the Report Manager
The Report Designer
The Main Components of the Design Environment | Menus | Toolbars | Windows | Usability Features | Creating a Data Source and Dataset | Create a Data Source | Create a Dataset | Query tab | Fields tab | Data Options | Parameters | Filters | Using the Graphical Query Designer | Designing the Layout | The Layout View | The Toolbox | Adding a Table Data Region | Adding Data Fields to a Table Data Region | A Closer Look at Preview | Adding Textboxes | Changing Columns and Rows | Adding or Deleting | Resizing | Moving | Table Data Region Record Sorting | Using Expressions | Using the Expression Editor Dialog | Grouping Data | General | Filters | Sorting | Visibility | Data Output
Query and Report Parameters
Query vs. Report Parameters | Create a Report Query | Add Report Parameter to a Dataset | Previewing a Report with Parameters | Displaying Parameters in a Report | Dynamic Parameter Values (From Query)
Formatting Reports
Report Item Style Properties | Quick Formatting using Toolbar and Menu Options | Report Formatting Toolbar | Report Borders Toolbar | Formatting Textboxes with the Textbox Properties Dialog | General | Visibility | Navigation | Font | Format | Interactive Sort | Data Output | Managing Tables with the Table Properties Dialog | General | Visibility | Navigation Sorting | Groups | Filters | Data Output | Setting the Report Properties | General | Layout | Code | Data Output | Drawing Lines and Rectangles
Administration
Managing Reporting Services | Using the Report Manager | Settings | Security | Other | SQL Server Management Studio | Overview | The Management Studio Object Explorer | Managing Objects in Object Explorer | Server Properties | Web Folder Properties | Data Source Properties | Shared Schedules | Using the Reporting Services Configuration Manager | Tools for Managing Reports | Deploying Reports with Development Studio | Linked Reports | Managing Parameters
Subscriptions, Snapshots, and Caching
Understanding Subscriptions | Creating a Subscription | Static Subscription | Data-driven Subscription | Understanding Snapshots | History Properties | Understanding Caching | Execution Properties
Security
Security Model Concepts | Understanding System-level Roles | Adding System-level Roles | Understanding Item-level Roles | Adding an Item-Level Role | Understanding Users and Groups | Understanding Security Settings | Default Folder Structure |Current Classroom Folder Structure | Adding Groups and Users | Adding Groups to Reporting Services | Adding Users | Auditing and Management Reports | Execution Log Reports | Server Management Reports | Installing Auditing and Management Reports | Deploying the Auditing and Management Reports | Deploy Sample Reports to Report Server | Create a Database for Report Execution Data | Configure and Run the Job Package | Run the Sample Reports
Building Report Models
Understand the Report Model Architecture | Creating a Report Model Project | Creating a Report Model Data Source | Creating a Data Source View | Modifying the Data Source View | Toolbar | Diagram Pane | Diagram Organizer Pane | Tables Pane | Creating a Report Model File | Report Model Generation Rules | Model Statistics | Understanding the Model Designer | Model Designer Layout| Entities | Attributes | Identifying Field | Roles | Entity and Field Folders | Perspectives | Deploying a Report Model
Using Report Builder
Understanding Report Builder | Launching Report Builder | Report Builder Design Layout | Getting Started Pane | Report Toolbar | Explorer Pane | Design Area | Building a Table Report | Adding Fields to the Table Data Region | Report Groupings | Previewing a Report | Formatting | Report Filters | Clickthrough Reports | Saving a Report | Building a Matrix (Cross-tab) Report | Creating Formulas | Creating a Chart Report | Parts of the Chart | Chart Types | Chart Options
System Requirements
Installation Instructions
Expression Functions for Development Studio
Formula Functions for Report Builder
|
