Rockwell Automation FactoryTalk Report Expert User Guide - Manual (Page 11)

Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014 11
Chapter 1
Welcome to Report Expert
Report Expert is a new reporting environment based on SQL Server
Reporting Services (SSRS) for Microsoft SQL Server that allows you
to report on data generated by FactoryTalk Metrics.
Report Expert is an optional component that is installed separately
from RSBizWare and the FactoryTalk Metrics software. To use
Report Expert, you must install one of the supported versions of
Microsoft SQL Server (see "Report Expert Prerequisites (page 17)").
Read the release notes (located on your Report Expert CD) to learn
about software/hardware requirements.
Report Expert provides a web interface to view and interact with
three types of reports that display FactoryTalk Metrics data:
• Quick Web reports, which are created with the RSBizWare
and FactoryTalk Metrics report authoring tools.
• SQL Server Reporting Services reports, which are created
using the SSRS report designer tools.
• Report Expert report templates (page 38), which are specially
modified SSRS reports.
A fixed number of Report Expert report templates are installed
automatically with Report Expert. These report templates, when
combined with parameter sets you can create, will satisfy a wide
range of reporting requirements. You can also create new Report
Expert report templates using SSRS. Creating new reports is an
advanced topic that is not covered in this user guide.