Using Microsoft SQL Server Reporting Services with Microsoft Dynamics GP 10.0

After completing this chapter, students will be able to:

List the benefits of using SQL Server Reporting Services together with Microsoft Dynamics GP.

Install the SQL Server Reporting Services Wizard.

List available reports, models, and data sources.

Demonstrate how to deploy data connections and reports, and make reports available in Microsoft Dynamics GP.

Make reports available on the My Reports list.

Explain the components of SQL Server Reporting Services.

Explain data regions available on reports and how they can be used.

This chapter provides report planning guidance and includes a planning checklist. Data storage in Microsoft Dynamics GP is investigated including the terminology, table names, types and groups. Direction is given in determining where information is located in Microsoft Dynamics GP, what the structure of returned data looks like, and relationships between tables.

Planning a Report

Data Storage

Determine Where Information Exists in Microsoft Dynamics GP

Identify the Data Structure Returned to the Data Set

Table Relationships

Report Planning

After completing this chapter, students will be able to:

Determine the needs for a report.

Describe how data is stored in Microsoft Dynamics GP.

Determine where information exists in Microsoft Dynamics GP.

Identify main tables, sorting and restricting requirements.

Identify table relationships to assist in creating SQL statements or stored procedures.

This chapter focuses on report creation and modification in the SQL Server Reporting Services Report Designer. Step-by-step instructions to create a new report are provided and common report enhancements are discussed. Deploying the report to the report server and using subscriptions to distribute reports are also discussed.

Collections

Report Creation

Report Layout

Use Properties to Enhance a Report

Parameters and Filtering

Publish and Execute Reports

Use Subscriptions to Distribute Reports

After completing this chapter, students will be able to:

Describe global collections that can be used on a report.

Create a report, data source, and data set.

Enhance a report by making modifications to the layout.

Show how to modify properties of items on a report.

Describe and use parameters.

Publish reports with Report Designer and view them in Report Manager.

Describe subscriptions and when to use them.

This chapter discusses using report models as the basis for a new report. Create the new report by using the report wizard in Report Designer or by using Report Builder. Common terminology and concepts are defined.

Report Models

Report Builder

After completing this chapter, students will be able to:

Describe and create a report model.

Use Report Builder to work with entities and folders, group, sort, and filter data, and view and publish a report.