Products

RBS ExcelTrend

Turn logged SQL Server data into shift reports

RBS ExcelTrend is the reporting application of RBS Report for Windows. It reads the rows that RBS Data Logger has stored in SQL Server and builds a report from your own Excel template.

Rows logged in SQL Server are turned into a report by RBS ExcelTrend and exported as Excel, PDF or CSV SQL Server logged rows ExcelTrend Shift report Excel · PDF · CSV

The problem

Shift reports are copied together by hand from raw SQL Server rows

Solution

Pick the time window, check the rows in a preview, export to Excel, PDF or CSV

What ExcelTrend does

  • Reads your SQL Server data

    Point a report at the SQL Server database and table that RBS Data Logger fills.

  • Uses your Excel template

    Define a report once. Pick an Excel template and map headings and SQL columns to its cells.

  • Selects the rows you need

    Filter by a time window or by other columns, then check the result in a preview.

  • Exports Excel, PDF and CSV

    One report definition exports to Excel, PDF or CSV.

How it works

  1. Step 1: Log the data

    RBS Data Logger writes your OPC UA tags to a SQL Server table.

  2. Step 2: Define the report

    In the Configuration program, choose an Excel template and map the SQL columns to cells.

  3. Step 3: Preview and export

    In ExcelTrend, select the rows for the shift, check the preview and export the report.

From SQL Server Rows to a Shift Report

Demo with simulated signals In our demo, RBS Data Logger had logged three simulated OPC UA signals to SQL Server. ExcelTrend builds the Line1 Shift Report from those rows.

  1. Select the rows in ExcelTrend Reports RBS ExcelTrend Reports screen with the Line1 Shift Report: filters for RealDate and ID and a preview of eight rows with MotorSpeed, BearingTemperature, Power and RealDate.

    The Line1 Shift Report with a time window and an ID range as filters. The preview shows the eight matching rows.

  2. Export the report PDF export of the Excel report with columns for motor speed, bearing temperature, power and timestamp, showing eight samples from 00:16:00 to 00:16:08.

    PDF export of the Excel report: the same eight samples.

Select an image to open it full size.

Windows today, web version planned

  • Windows: available

    RBS ExcelTrend is available on Windows as part of RBS Report. Request a demo to see it with your own data.

  • Web version: planned

    We plan a browser-based report designer and report engine that will run without Microsoft Excel. It has not been released and has no release date.

Frequently Asked Questions

Does ExcelTrend work with RBS Data Logger?

Yes. In our demo, RBS Data Logger logged three simulated OPC UA signals to SQL Server, and ExcelTrend built the report from the same rows.

Which export formats are available?

You can export a report as Excel, PDF or CSV.

Is the web version available?

No. The browser-based version is planned and has no release date. The Windows product is available now.

Want to see ExcelTrend with your own data?

Request a demo to see the path from your SQL Server tables to a finished report.