Video Library

Discover the power of XLReporter. Learn Anywhere. Learn Anytime.

Welcome to XLReporter

welcome to the next generation of reports, forms and dashboards.

Training

Training videos are based on the XLR User Results documentaion (see Documentaion in the Project Explorer). They provide step-by-step instruction on how to configure report templates, how to schedule them for automatic and on-demand reporting and various ways they can be distributed.
  • Course 101: Prerequisites
    play_s.pngCreating a Project Creating a project is the first step in generating reports
    play_s.pngTemplate Design Use "out-of-box" templates provided in the Library or design a custom template in the Microsoft Excel
    play_s_amber.pngScheduler The scheduler automates reporting and distribution by processing commands periodically or on events
    play_s_amber.pngData Placement Position report data in a report using a variety of methods e.g., row on the hour of a day
    play_s_amber.pngReport Names Select dynamic report names as a combination of text, dates and process values e.g., Lot ID
  • Course 102: Report from Process Data
    Report directly on process data (PLC) without a Historian or Relational Database.

    Topic 1: Report in Minutes with Template Library

    play_s.pngSummary Report Create a daily summary report from real-time data source with "out-of-box" templates.
    play_s.pngAdd Data Columns Modify the report by adding additional columns to the summary table

    Topic 2: Report Values Over Time

    play_s.pngSummary Report Create summary reports by logging process data over a period of time. Workbooks and worksheets are managed automatically.
    play_s_green.pngIntermediate Calculations Modify the report by adding intermediate Excel calculations.
    play_s_green.pngSummary and Chart Modify the report by adding an Excel chart and Excel formula to the summary table.

    Topic 3: Report Values on Event

    play_s.pngEvent Report Create summary reports by logging process data on events in the process. Workbooks and worksheets are managed automatically.
    play_s_green.pngSummary and Chart Modify the report by adding an Excel chart and Excel formula to the summary table.

    Topic 4: Report Values During Cycles

    play_s_amber.pngRegister Variables Register Variables are placeholders for parameters. Use in a report names, the period of a report, as report filters and more.
    play_s.pngCycle Report Create summary reports by logging process data during a cycle in the process e.g., batch. Workbooks and worksheets are named using a cycle ID.
    play_s_green.pngUser Comments Add annotation, such as user comments, to reports even while they are being updated.
  • Course 103: Report from Historians
    Report on historian data to produce key performance indicators, summary values and trends.

    Topic 2: Report Summary Values Over Time

    play_s.pngSummary Report Create summary reports containing "out-of-box" calculations. Workbooks and worksheets are managed automatically.
    play_s_green.pngCalculations and Charts Modify the report by adding intermediate Excel calculations, charts and formula.
  • Course 104: Report On-Demand and Dashboards
    Report on-demand and empower users with information about the process.

    Topic 1: On Demand Report in Minutes with Template Library

    play_s.pngSummary Report Create on-demand report templates with "out-of-box" templates. Deploy the templates across the network to authenticated users.

    Topic 2: On Demand Reports with Template Studio

    play_s.pngSummary Report Create on-demand report template that let users create custom reports by specifying their own parameters.
  • Course 105: Distributing Reports
    Deliver finished reports automatically by email, ftp and printer. Publish them for access by web browsers and smartphones.

    Topic 1: Email and SMS

    play_s.pngEmail Reports Automatically Email reports automatically on time or by events to ensure the right report, reaches the right person at the right time.
  • Course 106: PanelView Plus
    Use "stitching" technology to make the individual logs appear as a single data entity.
    play_s.pngLogging Process Data Data logging is performed by the DataStore Plus, configured in the PanelView Plus.
    play_s.pngProducing Reports Data transfer and report generation is performed automatically by XLReporter.