MW0033
Microsoft Dynamics NAV - SQL Server Reporting Services Training
This two day Microsoft Dynamics training is designed as an in depth training on the SQL Reporting Services in Microsoft Dynamics NAV context. This training will provide students with all necessary knowledge on SQL Reporting Services and how to make benefit of this tool with Microsoft Dynamics NAV context.
Audience
This Microsoft Dynamics NAV training is intended for technical consultants involved in Microsoft Dynamics Implementation projects
Content
Chapter 1: Introduction
Introducing SQL Server Reporting Services.Reporting Services Scenarios Creating, Managing, and Delivering Reports Overview. Reporting Services components and tools. In this chapter we introduce Reporting Services. What is Reporting Services? What are common scenarios and how we can use Reporting Services. You also get a general overview on how you can create, manage and deliver Reports. The components and tools that are a part of Reporting Services are also introduced.
Chapter 2: Installation & Configuration
Install client and server components on a single computer. Configure Report Server & install samples. In this chapter we will go over the installation procedure and options for Reporting Services. We also explain how the report server can be configured and how the report samples can be installed.
Chapter 3: Reporting Services Concepts
In this chapter the reporting services concepts like for example report definition, report snapshot, rendered report, report model, linked report, parameterized report, report server administrator, folder hierarchy are explained
Chapter 4: Creating a Basic Report
Here we will go into detail and explain how you create new reports using the Business Intelligence Studio Designer that comes with Reporting Services. We will start by creating a report server project and then creating a new report. Then we will setup the connection information and define a query for the report. After that the layout of the report needs to be defined (table, matrix, chart) . At the end we can preview the basic report.
Chapter 5: Adding Grouping, Sorting, and Formatting to a Basic Report
In this chapter the basic report created in the previous chapter will be refined by adding grouping, sorting, totals, subtotals and formatting options. Now we are ready to publish the report to the report server.
Chapter 6: Using a Dynamic Query in a Report
This advanced chapter is designed to help you understand how you can use dynamic queries in report design. In this chapter, you will create a project, create two datasets, add a table and parameters and alter one of the queries to use a dynamic query.
Chapter 7: Creating a Data-Driven Subscription
Reporting Services provides data-driven subscriptions so that you can customize the distribution of a report based on dynamic subscriber data. This chapter shows you how to use data-driven subscriptions step by step, using a simple example to help you understand the concepts.
Chapter 8: Creating a Report Model
This chapter is designed to help you create a report model based on the Navision Demo Database (5-0). You can also follow these steps to create models using your own data. In this chapter, you will set up connection information, define a view of the data source, define a report model, and publish the model to a report server. After you have completed this chapter, you can use the report model to build reports using Report Builder.
Chapter 9: Report Builder
Report Builder is a client-side application that information workers can use to create and design ad hoc reports. Using Report Builder, users can select data and design reports without having to understand how and where the data is stored. In this chapter we will cover the possibilities of report builder, create a new report and publish it on the report server.
Chapter 10: Report Manager
Report Manager is a Web-based report access and management tool that you access through Microsoft Internet Explorer. You can use Report Manager to administer a single report server instance from a remote location over an HTTP connection. You can also use Report Manager for its report viewer and navigation features.
Chapter 11: Report Server
The report server is the main component of Reporting Services. The report server is implemented as a Microsoft Windows service and as a Web service that provides an optimized and parallel processing infrastructure for processing and rendering reports. In this chapter we will explain the concept of report server and how the service can be managed and configured.
Chapter 12: Accessing the Report Server Web Service Using Visual Basic or Visual C#
This is a chapter contains step by step instructions for developers who want to programmatically access the report server web service via .NET code.
Chapter 13: Reporting Services Microsoft Dynamics-NAV Reporting Pack
On the Microsoft website there are some free reporting packs that can be downloaded and installed. One of these is a report pack that contains 22 reports running on a Microsoft Dynamics-NAV 4.0 database. In this chapter we explain how and where the report pack can be downloaded and installed and also how it can be modified/extended to run on a Microsoft Dynamics-NAV 5.0 database.
Chapter 14: What about Reporting Services and the Dynamics-NAV native database?
Retrieving data from a Microsoft Dynamics NAV native database. What about Report Builder? When you are working in Micosoft Dynamics NAV you have the choice between working with the native database or with Sql Server. In this chapter we will propose a way to work, a workaround, with Reporting Services on a Microsoft Dynamics NAV native database. The limitations of this solution are also discussed. For example it will not be possible to use the report builder in this situation.
Chapter 15: What about FlowFields, Table relations and foreign keys?
When working with Microsoft Dynamics NAV on a Sql Server database there are a few possibilities to also use FlowFields, table relations and foreign keys. These scenarios will be covered in this chapter.
Chapter 16: What about Table relations and foreign keys?