Creating a Report

From EMK Wiki
Jump to navigation Jump to search
Important Note: The report filter operates similarly to, but independently of the filter in the  data section section.
Filters set in the report section will be applied at report run time.
Filters set in the data section will be ignored at report run time.
Access
Through the Create tab in the report section.
CreateSaved.PNG


Report Definition

Creating.PNG



Settings Description Values
Report Name
Unique Name to identify each individual Report Definition
User defined, can be anything
Group by
Controls how the data is grouped together in the report. Changing this field will cause the fields in the Report Values area below to change
Can be grouped by Account, Category or ICP
Render As
Determines what format the report will be outputted in.
CSV - Report will be downloaded as a CSV file which can be viewed in excel
HTML - Report will open in a new tab as a HTML file
Report Settings
Report Aggregation controls the period over which report data is aggregated. For example if monthly is selected then the Report Data will be outputted in monthly totals
Monthly, Quarterly, Annually
Date Range
Controls the range of dates for which data is included in the report
Date From, Date To

>> To Run or Save the current Report Definition click on the corresponding button at the bottom left of the box


Home - Back

The Report Values Area

Report Values2.PNG

When "Account" or "ICP" are selected in the Group By field, the two boxes to the right will be shown.

The Selected Values box displays the values which will be shown on the report and the Unselected Values box shows values which can be shown but currently will not be.

>> To move values between the two boxes highlight the value to be moved and then click on the left arrow to move it from Selected Values to Unselected Values or vice-versa.



Report Values 3.PNG

When "Category" is selected in the Group By field, the Select Group box (shown to the left) will be shown instead of the two boxes above. This provides a drop down list of "categories" through which the data in the Report can be sorted by. For example if you were to select business unit then the aggregated data for each separate business unit would be shown in the Report.

Home - Back

Account Data Values

Report values 4.PNG

The Account Data Values appear at the bottom of the page and are used to control what actual recorded data is displayed in a report.

>> To edit these fields click on the blue pencil to the left of the row you wish to edit. Three drop down boxes will appear (as is shown in the top row of the example). Select the values you want to be displayed in the Report, and then click the blue tick to confirm your selection.

The top row of the example will display "Energy Consumption Invoiced" when the tick is clicked and that data along with the "Energy Consumption Normalised" and "Energy Consumption Variance" data will be displayed in the Report.

>> Rows can be deleted by clicking the cross beside the row to be deleted.

Another blank row is automatically added when the current row being edited is confirmed.

Home - Back