Knowledge Base Library
AVReporter introduction
Software requirements
Hardware requirements
Review of the AVReporter software packages
AVReporter Desktop Manager
Running the software
First startup (Configuration wizard)
Language setting
Step 1. Setting the database connection
Step 2. Selecting the database
Step 3. User name and password (to get access to the database)
Step 4. Reviewing the parameters and testing the database connection
Buildup of the User Interface of AVReporter Desktop Manager
File and Help bar
Preferences
Other settings
Visual settings
Importing and exporting AVReporter report groups
Menu bar
Application Browser
AVReporter settings
Main settings
Add ins (plugins)
Scheduler configuration
Registration
AVReporter reports (Working with Group)
Adding and deleting a report group
Modifying a report group
Moving report groups
Adding reports to the report group
AVReporter modules
Starting the AVReporter application modules
Operations with reports
Plugins
Printer Plugin
Mailer Plugin
Basic Reporter Module
Running the software
Settings
Setting the database connection
Connecting to Powerlogic SMS systems
Connecting to Powerlogic ION systems
Connecting to an EGX300 device
Connecting to AVReporter database (attach to other systems)
Connecting to database has failed
Define first day of the week and time shift in seconds
Rounding settings of calculations and different values
Font style of reports
Report appearance: colours and themes
Language settings
Make a report
First steps
Select type of report
Report window layout
Table report
Line chart
Histogram report
Pie chart
Save report
Save query
Print report
Energy Manager Summary Module
Running the software
Settings
Setting the database connection
Connecting to Powerlogic SMS systems
Connecting to Powerlogic ION systems
Connecting to an EGX300 device
Connecting to AVReporter database (attach to other systems)
Connecting to database has failed
Define starting day of the week and time shift in seconds
Using absolute value summary
Warning in case of unit dimension deviation
Rounding settings of calculations and different values
Font style of reports
Report appearance: colours and themes
Language settings
Creating a report
First steps
Selecting and searching for devices
Selecting the type of report to be displayed
Layout of the report window
Real and Reactive consumption report
Summarized reports
Report by devices
Reactive energy Into the Load - Out of the Load Rate
Real and reactive consumption report settings
Apparent energy consumption report
Apparent report in table form
Apparent energy consumption in column chart or in a pie chart
Apparent consumption report settings
Query table report (consumption reports not only on electric quantities)
Query table formatting
Show the main meter in the report
For example: Finding transformer loss
Assigning alias names to devices
User defined quantities
Save report
Saving an query
Print report
Business Intelligence Module
Running the software
Operation principle of the Business Intelligence Module
Definition of variables
Definition of expressions
Settings
Setting the data base connection (for quantity variables)
Connecting to Powerlogic SMS systems
Connecting to Powerlogic ION systems
Connecting to an EGX300 device
Connecting to AVReporter database (attach to other systems)
Connecting to database has failed
Defining starting day of the week, shifting of grouping time and second shifting
Visual settings
Rounding settings of calculations and different values
Font style of reports
Report appearance: colors and themes
Other settings
Language settings
Usage of Business Intelligence
Creating and Running queries
Creating Queries step by step
Example: Creation of a KPI report, where we determine the power consumption and costs by product unit
Step 1: Start the Business-Intelligence module from the Desktop Manager surface
Step 2: Create a new query
Step 3: Create variables
Step 4: Create our expressions
Step 5: a) Display data in a report
Display the result union in the report
Step 5 b) Export data into another data base
Export the result union into another data base
Save query
Main window of Business Intelligence
Menu bar
Expression groups
Operations
Time interval under survey (Global time interval)
Other filtering possibilities
Construction of the window of expression group
Result handling (Report, Exporting plugin)
Expressions
Displaying file settings (Report))
Variables
Group name
Export Plugins
CSV Export Plugin
ODBC Export Plugin
Handling and creating variables
Quantity variable
Constant variable
CSV variable
ODBC variable
Creating a connection string
ODBC Connection
String variable
User Input variable
Attributes of variables
Creating and editing expressions
Mathematical operations and functions in expressions
Attributes of expressions
Managing the result of queries
Report window layout
Managing queried errors and detecting errors
Syntax checking of expressions
Evaluation checking of expressions (List of group variable events)
Checking and follow-up of the running of export plugins (Event register, etc.)
Creating an own report
Embedding the Visual Basic code into the report
Print report
Save query
Logging of data by external application (from program code)
Registering AVRDataImporter.dll
Function of AVRDataImporter.dll
Application examples
Logging from SCADA systems (iFiX, WinCC, Citect, Vijeo Look, RSView ...)
Logging from Visual Basic .NET application
Logging from Visual Basic 6 application

Copyright by KONsys