Writing Reports with Report Designer and SSRS 2014 Level 1
€995, aangeboden door Master it Training
In deze tweedaagse training vindt er een introductie plaats tot de basis van rapporteren met Microsoft SQL Server Report Designer en SQL Server Reporting Services (SSRS). Er is een focus op het maken van rapporten door het verbinden met een database en deze data te manipuleren voor presentaties. Dit omvat: het maken van tabel en matrix rapporten, het stijlen van rapporten, het groeperen van rapport data, het maken van simpele en complexe expressies, het weergeven van verzamelingen data, het sorteren en filteren van data en het voorbereiden van rapporten voor printen en exporteren. De Rapport Designer is beschikbaar voor alle ondersteunde versies van Microsoft Server SQL.Na het volgen van de training kun je: Zelfstandig de Report Designer omgeving verkennen en gebruiken. Tabel rapporten maken. Matrix rapporten maken. Rapporten stijlen. Simpele en complexe expressies maken. Rapport data groeperen. Rapport data filteren en sorteren. Data samenvatten met grafieken. Rapporten printen en exporteren.
Let op. Deze training is exclusief het examen.
Doelgroep
Deze training is geschikt voor mensen die nieuw zijn met het rapporteren met Microsoft SQL Server Report Designer en SRSS, en mensen die overschakelen van andere software om rapporten te maken. Daarnaast is het geschikt voor mensen die al rapporteren met Report Designer of SRSS en meer willen leren.Het kan hier gaan om business, programmeur of data analisten, maar ook database beheerders en andere IT professionals. Ervaring met Microsoft SQL Server Report Designer, SRSS, programmeren (Visual Basic) en/of TransactStructured Query Language (TSQL) kan gebruikt worden maar is niet vereist.
Voorkennis voor de Writing Reports with Report Designer and SSRS 2014 Level 1 training
Voor het volgen van deze training is de volgende voorkennis nodig: Bekend zijn met Windows. Het creëren van en navigeren binnen folders. Het openen van programma’s. Het manipuleren van vensters. Het kopiëren en plakken van objecten. Het formatteren van tekst. Het opslaan van bestanden. Microsoft Office Access 2013: Level 1, of equivalente ervaring met database concepten.
Onderwerpen in de Writing Reports with Report Designer and SSRS 2014 Level 1 training
Module 1: Exploring the Report Designer EnvironmentThis module introduces the Report Designer application and its features. You will explore the Menu bar, the Toolbox, and the available Window panes for creating and manipulating reports, and the report design surface using Design and Preview modes.Lessons SQL Server Reporting Services The Report Designer Environment Working with Existing ReportsLab 1: Exploring the Report Designer Application Navigating the Menu bar and the Toolbox View Existing Reports in Design and Preview modesAfter completing this module, students will be able to: Describe the purpose of SQL Server Reporting Services. Describe and navigate the graphical elements of the Report Designer application. Work with existing reports and navigate between Design and Run modes.Module 2: Adding Data to Table ReportsThis module introduces report writers to populating a report with data and displaying the data in a table data region on the report. We will begin with defining the data source and continue with query building through data sets to bring data into the report. Next, we will explore the elements of the Tablix including rows, columns, cells, handles, and field choosers.Lessons Create Report Data Sources Create Report Datasets Create Table ReportsLab 1: Creating Table Reports Create Queries using the Report Designer Query Designer Create a Table Report using a Single Table Create Table Relationships using Query Designer Create a Table Report using Multiple TablesAfter completing this module, students will be able to: Create report data sources. Create report datasets. Work with the tablix data region. Create a table report.Module 3: Formatting Data and Creating Expressions in ReportsThis module introduces report formatting techniques which allow a report writer to control how and where data displays in the report. Additional data may also be required and this can be accomplished by adding data from a source or adding a calculated field to the dataset. Simple and complex expressions will also be introduced in this topic.Lessons Formatting Reports Sorting and Filtering Report Data Adding Data to a Dataset Creating Simple and Complex ExpressionsLab 1: Formatting Reports Format Tablix Columns Format Data in a Tablix Cell using Properties Format Data in a Tablix Cell using Simple and Complex Expressions Sort Data using Expressions Use Simple and Complex Expressions to Display Data in a TablixAfter completing this module, students will be able to: Format data in a report using the Report Designer Properties dialog boxes. Add data to a report and make changes to column names in the dataset query. Format data in a report using simple and complex expressions. Display data in a report using simple and complex expressions.Module 4: Grouping Report DataThis module introduces data groupings in reports using dataset fields and expressions. This module also discusses group hierarchies and adding aggregates to summarize grouped data.Lessons Group Data in Reports Group Data using an Expression Creating a Grouping Hierachy and using Group AggregatesLab 1: Creating Reports with Groups and Aggregates Display Grouped Data in a Report Create a Group Hierarchy in a Report Group Data using a Complex Expression Add Aggregates to Tablix RowsAfter completing this module, students will be able to: Group data in reports using fields. Group data in reports using expressions. Create group hierarchies. Aggregate grouped data in a report.Module 5: Matrix ReportsThis module introduces matrix data regions which are used in reports to control how crosstabular data can be used. While table reports rely on rows and columns, matrix reports rely on row groupings, column groupings, and aggregated values.Lessons Create and Modify Matrix Data Regions Create and Modify Column GroupsLab 1: Creating Matrix Reports Create Matrix Reports Create Column Groups Use Expressions to Sort Group Data Use Expressions to Display Group Names Create Matrix Reports with Grouping HierarchiesAfter completing this module, students will be able to: Describe the key features of using a matrix in a report. Create and modify matrix reports. Define column group hierarchies. Use expressions to define matrix headings and sort orders.Module 6: ChartsThis module introduces charting and the ability to create and add charts to reports. Chart reports allow us to visualize data with or without the details.Lessons Create and Modify Charts in Reports Modify Charts in ReportsLab 1: Creating Charts and Chart Reports Create a Chart Report Add a Chart to an Existing Report Format Chart Elements Use Expressions in ChartsAfter completing this module, students will be able to: Describe the key features of charts. Create charts. Modify chart data and the format of chart elements. Use expressions in charts.Module 7: Printing and Exporting ReportsThis module introduces report printing and exporting. Reports can be created for electronic display, paper display, or display in another application. This module covers the basics of those three scenarios.Lessons Print Features and Print Options Export ReportsLab 1: Printing and Exporting Reports Explore Page Layout view, Report Formatting, and Page Setup Options Export ReportsAfter completing this module, students will be able to: Describe the key features of electronic reporting vs. print reporting. Prepare a report for paper printing. Export reports in supported formats.