Program Level: Advanced 

This session introduces Microsoft SQL Server Reporting Services (SSRS) reports and their implementation in Epicor Kinetic. Microsoft SSRS is a server-based reporting platform that provides comprehensive reporting functionality to generate reports from SQL Server databases.  

To create the custom reports, the first workshops use Microsoft SQL Server Report Builder, a report authoring tool. Report Builder utilizes a Microsoft Office style environment, so its familiar interface makes it ideal for developing most of the custom reports. 

Cost: There is an additional $350 fee to attend this session. 

Objectives: 

• Embed images that are included in standard reports without the need for editing the SSRSreports 

• Use the NEW Cloud friendly ‘Generate for Design’ feature to edit SSRS reports without requiring a local download 

• Use the SSRS Report Builder to edit standard Epicor SSRS reports and custom SSRSreports 

• Add custom SSRS reports to the Epicor Kinetic menu and display them during runtime 

• Create new SSRS reports using BAQs as the data source 

• Add custom BAQ reports to the Epicor Kinetic menu and display them during runtime 

Audience: 

• System Administrators 

• IT/Technical Staff 

• Report Writers 

• Business Analysts 

Prerequisites: 

• Understanding of the Epicor Kinetic interface 

• Knowledge of report authoring programs 

• Knowledge of relational database concepts such as table relationships, records, and field types 

• Understanding of Business Activity Query (BAQ) functionality