Modifying batch reports, Sample data, Removing sample data from an sql server database – Rockwell Automation FactoryTalk Historian Classic for Batch User Guide User Manual

Page 50

Advertising
background image

Chapter 4 Analyzing Reports

To open a batch report, expand the BatchHistorian folder and click
the name of the report you want to open. The report opens in the
mode currently selected, Design mode or Preview mode. See the
FactoryTalk Historian Classic User Guide for more information
about viewing modes.

You can use the FactoryTalk Historian for Batch reports as
templates, modifying the reports for your particular use and saving
them with different names for future access. One way to modify
reports is to add or remove report objects. Any existing RSBizWare
report object can be used in a batch report, including text, chart,

time-series trend chart, picture, hyperlink, and any currently
registered ActiveX controls.

When FactoryTalk Historian for Batch is installed, sample data
from simulated batch production runs is installed in your database.
This allows you to immediately view data in the sample reports that
are provided when you install FactoryTalk Historian for Batch.

You can remove the sample batch data by modifying and then
running the

RemoveSampleBatchData.bat file (for SQL) or the

RemoveOracleSampleBatchData.bat (for Oracle) provided on the
RSBizWare CD. These files can be executed from the Windows
Run dialog box or from a command prompt.

Separate procedures are provided below for removing sample data
from a SQL Server database and from an Oracle database.

1. Insert the RSBizWare CD into the DVD drive on your

computer.

2. Copy both

RSBizWare\Support\RemoveSampleBatchData.bat

and

RemoveSampleBatchDataDML.sql from the RSBizWare

CD to a single directory on your computer.

3. Modify the following arguments in your copy of the

RemoveSampleBatchData.bat file:

Modifying Batch Reports

Sample Data

Removing Sample Data from
an SQL Server Database

50

Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014

Advertising