Course info

This course introduces Microsoft SQL Server Reporting Services (SSRS) reports and their implementation in Epicor ERP.

Microsoft SQL Server Reporting Services (SSRS) is a server-based reporting platform that provides comprehensive reporting functionality for generating reports from SQL Server databases.

For creating custom reports, the workshops in this course uses Microsoft SQL Server Report Builder, which is a report authoring tool that allows the user to get started quickly in a Microsoft Office-like environment.

Upon successful completion of this course, you will be able to:

• Use the SSRS Report Manager management tool and the Report Builder authoring tool to create custom reports.

• Add custom SSRS reports to the Epicor ERP application menu system and retrieve them for viewing.

• Edit an Epicor ERP shipped SSRS report.

• Create a BAQ report and then use the Report Builder authoring tool to design an SSRS report layout for the report.

• Create routing rules that determine how report output generates, prints, and distributes.

• Add an SSRS printer in the Epicor Client and print SSRS reports.

• Understand the report security resources available when working with custom and shipped SSRS reports in Epicor.