Creating Custom Alarm Activity Reports Using LogMate with SQL
Server Reporting Services®
LogMateAMS includes the ability to generate a large
variety of alarm activity reports, trends, and KPIs. Even
with the extensive on-board report capabilities, some
situations may require a unique analysis or report design.
As a solution for these ad-hoc reporting needs,
LogMateAMS links to the powerful SQL Server Reporting
Services® (SSRS) report builder. SSRS is a thin-client
utility included with standard Microsoft SQL Server®
packages. It gives SQL Server the ability to create virtually
any report without relying on an external report building
program.
LogMateAMS and SSRS can share settings such as
source database, date range, and active query, so
selections in a LogMate window seamlessly transfer to an
SSRS report. Reports built in SSRS can be accessed
directly from a LogMate window by clicking "SSRS" in the
main LogMate navigation menu.
Using SSRS
SSRS is a thin-client tool, accessible from any authorized
and compliant Internet Explorer® browser. The specifics of
using SSRS can be found in the extensive documentation
found in the SQL Server help files. The basic SSRS
environment consists of a report builder, categorized
report libraries, and administrative tools such as export,
copy, and rename.
The SSRS designer uses three basic components: a
calculation engine, a data entry or selection form, and a
results display area. Once the report is designed, it can be
named and made available for immediate recall by clicking
the report name in the browser. Reports can be
preconfigured to use specific data and criteria or they can
allow for custom data entry and selection.
Integration with LogMateAMS
SSRS and LogMateAMS share the same infrastructure as
far as SQL Server and the Internet Explorer thin-client
interface. The SSRS integration enables a LogMateAMS
screen to embed the SSRS viewer within the same
browser screen. LogMate simply needs to know the
location of the SSRS service.
Clicking the SSRS link in the main LogMate navigation
menu opens SSRS inside the LogMate framework and
passes the current LogMate settings (Database, Criteria,
Date Range) to the SSRS server. The desired report is
then selected from a drop down menu and the results are
displayed on screen.
If you have any questions or would like a demonstration of the SSRS integration, please
contact us.
Products
