EMO Wiki - User contributions [en]

Special:Badtitle/NS102:Account Groups

2013-10-06T22:19:34Z

Paul Chapman: Blanked the page

Special:Badtitle/NS102:Account Groups

2013-10-06T22:18:35Z

Paul Chapman: /* Delete Groups */

{{#hidens:}}
The Account Groups feature allows the user to download Account Groups Data from Ellserve, modify Account Groups Data or upload new Account Groups Data.

====[[Get Group Data|Get Group Data]]====

====[[Change Groups|Change Groups]]====

====[[Delete Groups|Delete Groups]]====

[[Ellserve:Ellserve|Home]] - [[Ellserve:Settings|Back]]

Special:Badtitle/NS102:Delete Groups

2013-10-06T22:18:20Z

Paul Chapman: Blanked the page

Special:Badtitle/NS102:Account Groups

2013-10-06T22:17:46Z

Paul Chapman: /* Change Groups */

{{#hidens:}}
The Account Groups feature allows the user to download Account Groups Data from Ellserve, modify Account Groups Data or upload new Account Groups Data.

====[[Get Group Data|Get Group Data]]====

====[[Change Groups|Change Groups]]====

===[[Ellserve:Delete Groups|Delete Groups]]===

[[Ellserve:Ellserve|Home]] - [[Ellserve:Settings|Back]]

Special:Badtitle/NS102:Change Groups

2013-10-06T22:17:29Z

Paul Chapman: Blanked the page

Special:Badtitle/NS102:Account Groups

2013-10-06T22:17:00Z

Paul Chapman: /* Get Group Data */

{{#hidens:}}
The Account Groups feature allows the user to download Account Groups Data from Ellserve, modify Account Groups Data or upload new Account Groups Data.

====[[Get Group Data|Get Group Data]]====

===[[Ellserve:Change Groups|Change Groups]]===

===[[Ellserve:Delete Groups|Delete Groups]]===

[[Ellserve:Ellserve|Home]] - [[Ellserve:Settings|Back]]

Special:Badtitle/NS102:Get Group Data

2013-10-06T22:16:44Z

Paul Chapman: Blanked the page

Special:Badtitle/NS102:Climate Data

2013-10-06T22:15:56Z

Paul Chapman: Blanked the page

Special:Badtitle/NS102:Ellserve

2013-10-06T22:11:45Z

Paul Chapman: /* System settings */

__NOTOC__
==Help and Information==

Welcome to the Ellserve help and user guide wiki!

====[[Standard Configuration|Standard configuration]]====
The layout and functions of the basic website.

====[[Configuring Ellserve|Customising Ellserve]]====
How to configure and use Ellserve.

====[[Ellserve Data|Ellserve data]]====
How to interpret the data available in Ellserve.

====[[Reporting | Reporting]]====
Using the Ellserve report generator.

====[[Settings | System settings]]====
Making background settings.

====[[Ellserve:FAQ's | FAQ's]]====
Answers to common "how do I .... ?" questions.

====[[Ellserve:Glossary|Glossary]]====
Definitions of terms used in Ellserve.

[[File:Logo1.png|center|200px|Frame|Site Configuration Cog Icon]]

Special:Badtitle/NS102:Settings

2013-10-06T22:11:29Z

Paul Chapman: Blanked the page

Special:Badtitle/NS102:Settings

2013-10-06T22:11:20Z

Paul Chapman:

__NOTOC__
The Settings section is accessed by clicking on the "Settings" tab in the '''[[Ellserve:Header Banner |Header Banner]]'''.
[[File:Settings Banner.PNG|right]]

The following Settings pages can be accessed by clicking on the corresponding tab in the Settings Banner (shown to the right).

====[[Ellserve:Site Settings|Site Settings]]====

====[[Ellserve:User Settings|User Settings]]====

====[[Ellserve:Climate Data|Climate Data]]====

====[[Ellserve:Account Groups|Account Groups]]====

[[Ellserve:Ellserve|Home]]

Special:Badtitle/NS102:Settings

2013-10-06T22:10:55Z

Paul Chapman:

__NOTOC__
The Settings section is accessed by clicking on the "Settings" tab in the '''[[Ellserve:Header Banner |Header Banner]]'''.
[[File:Settings Banner.PNG|right]]

The following Settings pages can be accessed by clicking on the corresponding tab in the Settings Banner (shown to the right).

====[[Ellserve:Site Settings|Site Settings]]====

===[[Ellserve:User Settings|User Settings]]====

====[[Ellserve:Climate Data|Climate Data]]====

====[[Ellserve:Account Groups|Account Groups]]====

[[Ellserve:Ellserve|Home]]

Special:Badtitle/NS102:Settings

2013-10-06T22:10:35Z

Paul Chapman:

The Settings section is accessed by clicking on the "Settings" tab in the '''[[Ellserve:Header Banner |Header Banner]]'''.
[[File:Settings Banner.PNG|right]]

The following Settings pages can be accessed by clicking on the corresponding tab in the Settings Banner (shown to the right).

====[[Ellserve:Site Settings|Site Settings]]====

===[[Ellserve:User Settings|User Settings]]====

====[[Ellserve:Climate Data|Climate Data]]====

====[[Ellserve:Account Groups|Account Groups]]====

[[Ellserve:Ellserve|Home]]

Special:Badtitle/NS102:Ellserve

2013-10-06T20:56:55Z

Paul Chapman:

__NOTOC__
==Help and Information==

Welcome to the Ellserve help and user guide wiki!

====[[Standard Configuration|Standard configuration]]====
The layout and functions of the basic website.

====[[Configuring Ellserve|Customising Ellserve]]====
How to configure and use Ellserve.

====[[Ellserve Data|Ellserve data]]====
How to interpret the data available in Ellserve.

====[[Reporting | Reporting]]====
Using the Ellserve report generator.

====[[Ellserve:Settings | System settings]]====
Making background settings.

====[[Ellserve:FAQ's | FAQ's]]====
Answers to common "how do I .... ?" questions.

====[[Ellserve:Glossary|Glossary]]====
Definitions of terms used in Ellserve.

[[File:Logo1.png|center|200px|Frame|Site Configuration Cog Icon]]

Special:Badtitle/NS102:Ellserve

2013-10-06T20:50:58Z

Paul Chapman:

Special:Badtitle/NS102:Ellserve

2013-10-06T20:46:02Z

Paul Chapman:

Special:Badtitle/NS102:Ellserve

2013-10-06T20:45:50Z

Paul Chapman:

Special:Badtitle/NS102:Ellserve

2013-10-06T20:44:57Z

Paul Chapman:

Special:Badtitle/NS102:Ellserve

2013-10-06T20:44:39Z

Paul Chapman:

Special:Badtitle/NS102:Ellserve

2013-10-06T20:44:28Z

Paul Chapman:

Special:Badtitle/NS102:Ellserve

2013-10-06T20:43:08Z

Paul Chapman:

Special:Badtitle/NS102:Ellserve

2013-10-06T20:41:17Z

Paul Chapman:

Special:Badtitle/NS102:Ellserve

2013-10-06T20:41:02Z

Paul Chapman:

Special:Badtitle/NS102:Ellserve

2013-10-06T20:40:37Z

Paul Chapman:

File:Logo1.png

2013-10-06T20:39:34Z

Paul Chapman:

Special:Badtitle/NS102:FAQ's

2013-10-04T02:45:01Z

Paul Chapman: /* Pull a report? */

__NOTOC__

=='''How do I ...'''==

====[[Ellserve:Data | Edit group data?]]====

====[[Running Reports|Pull a report?]]====

====[[Editing Account Details | Edit individual account details?]]====

====Find accounts with ...====

*[[Editing Account Details | The highest total cost?]]

*[[Editing Account Details | The highest total consumption?]]

*[[Editing Account Details | The highest unit cost?]]

====[[Date Picker Configuration#Using the date picker|Use the date picker]]====

[[Ellserve:Ellserve|Home]]

Special:Badtitle/NS102:FAQ's

2013-10-04T02:44:24Z

Paul Chapman: /* Download reports? */

__NOTOC__

=='''How do I ...'''==

====[[Ellserve:Data | Edit group data?]]====

====[[ReportsFAQ | Pull a report?]]====

====[[Editing Account Details | Edit individual account details?]]====

====Find accounts with ...====

*[[Editing Account Details | The highest total cost?]]

*[[Editing Account Details | The highest total consumption?]]

*[[Editing Account Details | The highest unit cost?]]

====[[Date Picker Configuration#Using the date picker|Use the date picker]]====

[[Ellserve:Ellserve|Home]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:28:44Z

Paul Chapman: Blanked the page

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:28:15Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates similarly to, but independently of the filter in the '''[[Ellserve:Ellserve Data |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.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
| Width="175" Align="Left"|
:Through the '''Create''' tab in the report section.
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:27:48Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates similarly to, but independently of the filter in the '''[[Ellserve:Ellserve Data |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.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
| Width="175" Align="Left"|
:Through the '''Create''' tab in the report section.
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:27:37Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates similarly to, but independently of the filter in the '''[[Ellserve:Ellserve Data |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.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
| Width="180" Align="Left"|
:Through the '''Create''' tab in the report section.
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:27:23Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates similarly to, but independently of the filter in the '''[[Ellserve:Ellserve Data |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.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
| Width="200" Align="Left"|
:Through the '''Create''' tab in the report section.
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:27:11Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates similarly to, but independently of the filter in the '''[[Ellserve:Ellserve Data |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.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
| Width="2000" Align="Left"|: Through the '''Create''' tab in the report section.
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:26:55Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates similarly to, but independently of the filter in the '''[[Ellserve:Ellserve Data |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.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
| Width="2000" Align="Left"|
: Through the '''Create''' tab in the report section.
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:26:24Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates similarly to, but independently of the filter in the '''[[Ellserve:Ellserve Data |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.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
| Width="200" Align="Left"|Through the '''Create''' tab in the report section.
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:26:07Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates similarly to, but independently of the filter in the '''[[Ellserve:Ellserve Data |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.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
| Width="100" Align="Center"|Through the '''Create''' tab in the report section.
|
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:24:51Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates similarly to, but independently of the filter in the '''[[Ellserve:Ellserve Data |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.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:23:44Z

Paul Chapman:

Important Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:23:06Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|
| Width="400" Align="Center"|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:22:53Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|
| Width="400" Align="Center"[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:22:32Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="100" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|
| Width=400" Align "Center"[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:21:20Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="50" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|[[File:CreateSaved.PNG|right]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:20:50Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="50" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|[[File:CreatSaved.PNG|right|400px|centre]]
|}
[[File:CreateSaved.PNG|right]]

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:20:12Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="50" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|[[File:CreatSaved.PNG|400px|centre]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:17:58Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="50" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|[[File:Creating.PNG|700px|centre]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:17:34Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="300" Align="Center"|'''Access'''
|
:Through the '''Create''' tab in the report section.
|[[File:Creating.PNG|700px|centre]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:16:58Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="300" Align="Center"|'''Access'''
!-
|
:Through the '''Create''' tab in the report section.
|[[File:Creating.PNG|700px|centre]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:16:07Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="300" Align="Center"|'''Access'''
!-
:Through the '''Create''' tab in the report section.
|[[File:Creating.PNG|700px|centre]]
|}

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:14:32Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="300" Align="Center"|'''Access'''
!-
:Through the '''Create''' tab in the report section.
|-
|
:Report Name
|
:Unique Name to identify each individual Report Definition
|
:User defined, can be anything
|-

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

Special:Badtitle/NS102:Creating a Report

2013-10-04T01:12:59Z

Paul Chapman:

{{#hidens:}}
The Create a Report section provides the tools to create, run and save new [[Ellserve:Glossary#Report|Report]] [[Ellserve:Glossary#Definition|Definitions]].

Note: The report '''[[Ellserve:Filtering Functions |filter]]''' operates in similar to, bit independently to the filter in the '''[[Ellserve:Ellserve Data |data section]]''' section.
Filters set in the report section will be applied at report run time.

{|class="wikitable" style="text-align: left; color: black;"
! Width="300" Align="Center"|'''Access'''
!-
| Through the '''Create''' tab in the report section.
! Width="200"|'''Values'''
|-
|
:Report Name
|
:Unique Name to identify each individual Report Definition
|
:User defined, can be anything
|-

== The Report Settings Box ==

The Report Settings box (shown below) appears at the top of the Create a Report section.
[[File:Creating.PNG|700px|centre]]

{|class="wikitable" style="text-align: left; color: black;"
| Width="150" Align="Center"|'''Settings'''
| Width="300"|'''Description'''
| Width="200"|'''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'''

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== The Report Values Area ==
[[File:Report Values2.PNG|600px|right]]
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.

[[File:Report Values 3.PNG|left]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]

== Account Data Values ==
[[File:Report values 4.PNG|right]]
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.

[[Ellserve:Ellserve|Home]] - [[Ellserve:Reporting|Back]]