Introduction

Sigma Standard Reporting has two Activities that allow you to run reports across your database. This handout out relates to the Reporting Activity.

Opening the Reporting Activity

Opening the Reporting Activity

Click on the Reporting activity

Choosing the Items

Not all reports run on all Items. The report will be highlighted if it is compatible with the Item you have selected. 

Choosing the Items

Using the Data Selector, choose the Item(s) you want to run the report on. For instance, the Site Monthly Profile report would use Sites, whereas the Account Cost by Bill uses the Sites or Accounts

Use any of the selection methods such as Item Finder, Multi-List Selector or Tree Selector.

Choosing the Report

There are many standard reports in Sigma and they are listed on the right-hand side of the Reporting Activity. Each report has an icon against it, denoting which Items the report can run on.

 Understanding the list of Reports

Each report has a symbol at the beginning, the name of the report and then the Items icons

The symbol at the beginning shows whether you will produce one report or a multiple of reports. For example, the Site Monthly Multi-line Profiles would be one report made up of all the Sites you have selected, whereas the Site Monthly Profile would produce a report for each selected Site

The Icon at the end denotes the types of Items the report can run on. For example, The Site Monthly Profile can run on a site, Site Group, Organisation or TSP (Time Series Provider) - Items such as Accounts, Meters, Channels and Monitoring Points

Completing the criteria

Each report has a different set of criteria to complete before you can run the report. Some reports require Monitoring Points and/or Cost Definitions setting up before running the report.

Completing the criteria

Once you have chosen the Items and the Report, you need to complete the criteria.

This criteria is for the Site Monthly Report and requires a Monitoring Point and a Cost Definition. There is also an option to Append the costs from the Cost Definition.

Running the Report

Once you have chosen the Items to run the report on, the report name and completed the criteria, you can run the report to view it on screen.

Running the Report

Click Run Report and wait for the report to pop up on screen

Viewing multiple reports

 If you have chosen a report that created multiple reports, you will see them listed in the Document section at the top of the report.

Viewing the other reports

Click on each report to view on screen

Exporting the Report

Exporting the Report

The report can be exported to Excel or PDF

Click on the icons at the top of the report.