Digi Academy

SQL Server 2012 Reporting Services

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

Reporting Services Features Tools Available with SQL Server 2012 SQL Server Documentation Understand Reporting Services Features. Identify the SQL Server 2012 Tools. Find and Use SQL Server Documentation.

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Cosa impari in questo corso?

Visual Studio 2010
Server
Reporting
Visual studio 2008
Visual Studio
SQL

Programma

This module covers working with solutions and projects within Visual Studio.


Working with SQL Server Data Tools


Understanding Solutions and Projects


Working with the Visual Studio Interface


Creating and Managing a Project


Work with SQL Server Data Tools.


Understand solutions and projects.


Work with the Visual Studio interface.


This module covers building reports from start to finish, and tips and tricks for successful report building.


What is a Data Source?


What is a Dataset?


Using the Report Wizard


What is Tablix?


Creating a Tabular Report


Creating a List Report


What is a Matrix?


Deploying a Project


Creating Shared Data Sources and Datasets


Using the Report Wizard


Building a Basic Matrix Report


Understand the differences between shared and embedded data sources and datasets.


Create shared and embedded data sources and datasets


Use the Report Wizard to build basic reports.


Create a basic matrix report from a shared dataset.


This module covers the features which enhance the visual impact of reports.


Working with Text Boxes


Rich Text Formatting


Managing Text Boxes


Drawing Lines and Boxes


Images


Page Headers and Footers


Adding a Document Map


Rendering Reports


Formatting a Tablix Data Region


Enhancing a Report


Format data to enhance a report.


Add images to a report.


Work with page headers and footers.


This module covers expressions and how to use them to set dynamically changing properties or values.


Understanding Expressions


Defining Expressions


Working with Report Variables


Understanding Lookup, LookupSet, and Multilookup Functions


Expression Samples


Using Expressions to Work with Dates


Using Expressions to Manipulate Data


Use expressions to work with custom formulas.


Use expressions to change the way data is displayed in report.


Use expressions to incorporate data from more than one dataset.


SQL Server Reporting Services (SSRS) offers grouping features to allow you to summarize data and then drill down into the details below the summary levels. This module will explain how to create and manage these groupings.


Creating Groups


Parent/Child vs. Adjacent Groupings


Adding Totals and Aggregations


Creating Aggregates of Aggregates


Adding Parent Groups to a Report


Working with Groups


Add both row and column parent groups to an existing report.


Aggregate data for summary reports.


Create reports using adjacent groups in a matrix.


Work with group properties.


Paramaterized reports allow users to customize reports to show only the data they are interested in. This module covers the use of parameters and filters.


 Adding Parameters to a Report


Report Parameters vs. Query Parameters


Manage Report Parameter Properties


Use Parameters with SQL Queries and Stored Procedures


Work with Cascading Parameters


Sort Based on a Parameter Setting


Filtered Reports


Adding Parameters


Customize report data with both query and report parameters.


Use parameters to define interactive sort and visibility options.


Add filters to a dataset.


This module explores the different ways data can be enhanced visually in a report.


Charts


Gauges


Add a Map to a Report


Data Bar, Indicator, and Sparkline Report Items


Nesting Data Regions


Sub-reports and Drill-through Reports


Working with Drill-through Reports


Creating a complete solution (if time permits)


Adding data visualization report items to a report


Adding a correlated sub-report


Use lessons up to this point to create a complete solution.


Choose between data visualization options.


Add data visualization items to an existing report.


Add a drill-through report send parameters to the drill-through report.


This module provides details on how to run and manage reports using Report Manager.


Deployment


Navigating Report Manager


Understanding Permissions


Viewing Reports


Working with Shared Data Sources


Managing Reports


Lab : Using Report Manager


Creating and Deploying Projects


Working with Report Manager


Create and deploy a project by using SSDT.


Work with Report Manager to view and manage reports.


Create a linked report.


Add report snapshots by using Report Manager.


This module covers the use of Report Builder to apply lessons learned in previous modules.


ClickOnce vs. Stand-alone


Installing the Stand-alone Version


Using the Report Builder Tool


Creating Datasets


Creating Reports


Creating Reports Using Wizards


Creating Reports Without a Wizard


OPening Existing Reports


Working with Report Parts


Creating a basic report by using Report Builder


Adding data visualization report items to a report


Implement basic features from previous modules in Report Builder


Add data visualization items to a report using Report Builder.



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto