Creating Reports

From Subscribe-HR Wiki Help
Jump to: navigation, search
Line 11: Line 11:
 
<br>
 
<br>
 
<br>
 
<br>
# After logging into Subscribe-HR, Select Tools > Reports > ‘My Reports’ SubTab.[[File:Report-Create.jpg]]  <br>& Select the '''Create''' button.  <br>Or click on '''New Report''' on the '''Quick Link Bar'''.[[File:Report-NewReport.jpg]]
+
# After logging into Subscribe-HR, Select Tools > Reports > ‘My Reports’ SubTab. [[File:Report-Create.jpg]]  <br>& Select the '''Create''' button.  <br>Or click on '''New Report''' on the '''Quick Link Bar'''. [[File:Report-NewReport.jpg]]
 
# Select the '''Public''' check box.  <br>By selecting the Public check box you are making this report available to all users.  <br>By removing the check from the Public check box you are making this report private and only available to users with permissions.
 
# Select the '''Public''' check box.  <br>By selecting the Public check box you are making this report available to all users.  <br>By removing the check from the Public check box you are making this report private and only available to users with permissions.
 
# Select the '''Report Type'''  from the dropdown, such as ‘Human Resources’, ‘Recruitment’, etc.
 
# Select the '''Report Type'''  from the dropdown, such as ‘Human Resources’, ‘Recruitment’, etc.
Line 22: Line 22:
 
# Select the '''Format''' you want the report delivered in.
 
# Select the '''Format''' you want the report delivered in.
 
# Select the '''Frequency''' you would like to send report.
 
# Select the '''Frequency''' you would like to send report.
# Select the '''Recipients''' by selecting the user.[[File:Report-Sched.jpg]]
+
# Select the '''Recipients''' by selecting the user. [[File:Report-Sched.jpg]]
# '''Save''' Report before Joining Tables or setting up fields.[[File:Report-SchedSaved.jpg]]
+
# '''Save''' Report before Joining Tables or setting up fields. [[File:Report-SchedSaved.jpg]]
  
 
===Join Tables===
 
===Join Tables===
 
# After ticking '''Join Tables (Advanced)''' & then saving the Report, this will then activate the Join Tables SubTab.
 
# After ticking '''Join Tables (Advanced)''' & then saving the Report, this will then activate the Join Tables SubTab.
# On the Join Tables SubTab, enter Table (Object) name (or part of) you wish to include in the Join.[[File:Report-Join-Search.jpg]]<br>
+
# On the Join Tables SubTab, enter Table (Object) name (or part of) you wish to include in the Join. [[File:Report-Join-Search.jpg]]<br>
# Click on table, then drag line to next table to join them.[[File:Report-Join-Link.jpg]]
+
# Click on table, then drag line to next table to join them. [[File:Report-Join-Link.jpg]]
 
# Then you will be prompted to select required '''From Field''' & '''To Field''' to join, then the '''Join Type''':  <br>'''LEFT JOIN''' shows all records from left table regardless of the existence of matching records in the right table.  <br>'''RIGHT JOIN''' means opposite of LEFT JOIN. It shows all records from the second (right) table and only matching records from first (left) table.  <br>'''INNER JOIN''' shows all records where there is at least one match in either table.
 
# Then you will be prompted to select required '''From Field''' & '''To Field''' to join, then the '''Join Type''':  <br>'''LEFT JOIN''' shows all records from left table regardless of the existence of matching records in the right table.  <br>'''RIGHT JOIN''' means opposite of LEFT JOIN. It shows all records from the second (right) table and only matching records from first (left) table.  <br>'''INNER JOIN''' shows all records where there is at least one match in either table.
* Click '''OK''' & repeat process for other Tables to include.
+
# Click '''OK''' & repeat process for other Tables to include. [[File:Report-Join-Done.jpg]]
[[File:Report-Join-Done.jpg]]
+
# '''Save''' changes, before moving onto the Fields SubTab.
* '''Save''' changes, before moving onto the Fields SubTab.
+
  
 
===Fields===
 
===Fields===
* Select the Fields SubTab.
+
# Select the Fields SubTab.
* To find the required Field (Element), start typing in the Fields section. This will show in a dropdown of all available Fields matching the search criteria.
+
# To find the required Field (Element), start typing in the Fields section. This will show in a dropdown of all available Fields matching the search criteria. [[File:Report-Fields-Search.jpg]]
[[File:Report-Fields-Search.jpg]]
+
# Optionally select the field(s) to '''Group''' the Report by. [[File:Report-Fields-Done1.jpg]]
* Optionally select the field(s) to '''Group''' the Report by.
+
# '''Save''' changes.
[[File:Report-Fields-Done1.jpg]]
+
* '''Save''' changes.
+
  
 
====Totals & Aggregate Functions====
 
====Totals & Aggregate Functions====
* Click on the '''Pencil Icon''' [[File:Report-Fields-Pencil.jpg]] on the right of the Field. Select from the dropdowns, the '''Basic Function''' (Average, Count, Max, Min or Sum).  
+
# Click on the '''Pencil Icon''' [[File:Report-Fields-Pencil.jpg]] on the right of the Field. Select from the dropdowns, the '''Basic Function''' (Average, Count, Max, Min or Sum). <br>[[File:Report-Fields-Function.jpg]]
[[File:Report-Fields-Function.jpg]]
+
# The '''Calculate Total''' field is populated with a check box when a numeric field is added. [[File:Report-Fields-Calc.jpg]] <br>If the check box is selected this will provide a total of all numeric values at the bottom of the report, if the report is grouped by a field, then the total is placed at the bottom of each grouping.  
* The '''Calculate Total''' field is populated with a check box when a numeric field is added.
+
# '''Save''' changes.
[[File:Report-Fields-Calc.jpg]]<br>
+
:If the check box is selected this will provide a total of all numeric values at the bottom of the report, if the report is grouped by a field, then the total is placed at the bottom of each grouping.  
+
* '''Save''' changes.
+
  
 
====Formatting====
 
====Formatting====
* Click on the '''Pencil Icon''' [[File:Report-Fields-Pencil.jpg]] on the right of the Field. The '''Date Formatting''' field is populated with a drop down when a date field is added.
+
# Click on the '''Pencil Icon''' [[File:Report-Fields-Pencil.jpg]] on the right of the Field. The '''Date Formatting''' field is populated with a drop down when a date field is added. <br>[[File:Report-Fields-Formating.jpg]] <br>If formatting is selected such as Month Name this will only display the Month name in the report and not the dd/mm/yyyy.
[[File:Report-Fields-Formating.jpg]]
+
# '''Save''' changes.
:If formatting is selected such as Month Name this will only display the Month name in the report and not the dd/mm/yyyy.
+
* '''Save''' changes.
+
  
 
====Sorting====
 
====Sorting====
* Click on the '''Pencil Icon''' [[File:Report-Fields-Pencil.jpg]] on the right of the Field. The '''Sorting Order''' field is populated with a drop down for all fields.
+
# Click on the '''Pencil Icon''' [[File:Report-Fields-Pencil.jpg]] on the right of the Field. The '''Sorting Order''' field is populated with a drop down for all fields. [[File:Report-Fields-Sort.jpg]] <br>Selecting the sort order of either '''Ascending''' or '''Descending''' for a field will cause the report to output the data in either an Ascending or Descending order highest to lowest.  
[[File:Report-Fields-Sort.jpg]]
+
# '''Save''' changes.
:Selecting the sort order of either '''Ascending''' or '''Descending''' for a field will cause the report to output the data in either an Ascending or Descending order highest to lowest.  
+
* '''Save''' changes.
+
  
 
====Condition====
 
====Condition====
 
Conditions are used to filter your report based on a criteria.
 
Conditions are used to filter your report based on a criteria.
* Down the bottom of the '''Fields''' SubTab there is the '''Condition''' section.
+
# Down the bottom of the '''Fields''' SubTab there is the '''Condition''' section.
* Select the field you wish to filter by.
+
# Select the field you wish to filter by.
* Select the filter type. The filter type varies depending on what field you are filtering on.<br>The most common are '''Equals To''', '''Not Equals To''', '''Is Last''', '''This Last''', '''Is Next'''.
+
# Select the filter type. The filter type varies depending on what field you are filtering on. <br>The most common are '''Equals To''', '''Not Equals To''', '''Is Last''', '''This Last''', '''Is Next'''.
* Select or Enter the value you are filtering on.
+
# Select or Enter the value you are filtering on.
* For more than one Condition an '''AND''' or a '''OR''' operator can be selected.
+
# For more than one Condition an '''AND''' or a '''OR''' operator can be selected.
* You can select multiple results for some fields by clicking on '''Options''' (if available) as shown below.
+
# You can select multiple results for some fields by clicking on '''Options''' (if available) as shown below. [[File:Report-Fields-Options.jpg]]
[[File:Report-Fields-Options.jpg]]
+
# To group Condition clauses together, brackets can be used. This is done by clicking on the Greater Than icon [[File:Report-Fields-Bracket.jpg]] to the right of the Field in the Condition clause. Clicking on the Less Than icon will remove a Bracket. <br>The below Condition clause can be written as: <br>IF ('''Leaver''' = No OR '''Last Day of Work''' is Last Week) AND '''Department'''=”''???list of Department???''” [[File:Report-Fields-Done2.jpg]]
* To group Condition clauses together, brackets can be used. This is done by clicking on the Greater Than icon [[File:Report-Fields-Bracket.jpg]] to the right of the Field in the Condition clause. Clicking on the Less Than icon will remove a Bracket.
+
# '''Save''' changes.
:The below Condition clause can be written as:
+
::IF ('''Leaver''' = No OR '''Last Day of Work''' is Last Week) AND '''Department'''=”''???list of Department???''”
+
[[File:Report-Fields-Done2.jpg]]
+
* '''Save''' changes.
+
  
 
===View Report===
 
===View Report===
Line 81: Line 67:
 
<br>
 
<br>
 
Only reports that are '''Grouped'' by can generate a Graph, otherwise a plain table of results will be generated.
 
Only reports that are '''Grouped'' by can generate a Graph, otherwise a plain table of results will be generated.
* Select the '''View Report''' SubTab.
+
# Select the '''View Report''' SubTab.
 
[[File:Report-View1.jpg]]
 
[[File:Report-View1.jpg]]
 
[[File:Report-View2.jpg]]
 
[[File:Report-View2.jpg]]

Revision as of 00:51, 24 January 2013

Currently Under Construction for Report Writer Modifications

Creating Reports

The Subscribe-HR Software system is Object Orientated and this is the same for Reports. The ability to add particular fields into a report solely relies on that field being part of the object.

  1. After logging into Subscribe-HR, Select Tools > Reports > ‘My Reports’ SubTab. Report-Create.jpg
    & Select the Create button.
    Or click on New Report on the Quick Link Bar. Report-NewReport.jpg
  2. Select the Public check box.
    By selecting the Public check box you are making this report available to all users.
    By removing the check from the Public check box you are making this report private and only available to users with permissions.
  3. Select the Report Type from the dropdown, such as ‘Human Resources’, ‘Recruitment’, etc.
  4. Enter the Report Name. Ensure the report name is descriptive.
  5. Select the Object this Report is to be based upon.
  6. If you want to retrieve data from more than one Object (Table), tick the Join Tables (Advanced).
  7. Select the Display Empty Records if required. This displays all entries in an object and sub-object relationship, so that all entries in the object can be viewed even if they do not have an entry in the sub-object.
  8. Enter a report Description if required.
  9. Enable the Report Scheduler if required.
    If Report Scheduler is selected, then you will get the following options:
  10. Select the Format you want the report delivered in.
  11. Select the Frequency you would like to send report.
  12. Select the Recipients by selecting the user. Report-Sched.jpg
  13. Save Report before Joining Tables or setting up fields. Report-SchedSaved.jpg

Join Tables

  1. After ticking Join Tables (Advanced) & then saving the Report, this will then activate the Join Tables SubTab.
  2. On the Join Tables SubTab, enter Table (Object) name (or part of) you wish to include in the Join. Report-Join-Search.jpg
  3. Click on table, then drag line to next table to join them. Report-Join-Link.jpg
  4. Then you will be prompted to select required From Field & To Field to join, then the Join Type:
    LEFT JOIN shows all records from left table regardless of the existence of matching records in the right table.
    RIGHT JOIN means opposite of LEFT JOIN. It shows all records from the second (right) table and only matching records from first (left) table.
    INNER JOIN shows all records where there is at least one match in either table.
  5. Click OK & repeat process for other Tables to include. Report-Join-Done.jpg
  6. Save changes, before moving onto the Fields SubTab.

Fields

  1. Select the Fields SubTab.
  2. To find the required Field (Element), start typing in the Fields section. This will show in a dropdown of all available Fields matching the search criteria. Report-Fields-Search.jpg
  3. Optionally select the field(s) to Group the Report by. Report-Fields-Done1.jpg
  4. Save changes.

Totals & Aggregate Functions

  1. Click on the Pencil Icon Report-Fields-Pencil.jpg on the right of the Field. Select from the dropdowns, the Basic Function (Average, Count, Max, Min or Sum).
    Report-Fields-Function.jpg
  2. The Calculate Total field is populated with a check box when a numeric field is added. Report-Fields-Calc.jpg
    If the check box is selected this will provide a total of all numeric values at the bottom of the report, if the report is grouped by a field, then the total is placed at the bottom of each grouping.
  3. Save changes.

Formatting

  1. Click on the Pencil Icon Report-Fields-Pencil.jpg on the right of the Field. The Date Formatting field is populated with a drop down when a date field is added.
    Report-Fields-Formating.jpg
    If formatting is selected such as Month Name this will only display the Month name in the report and not the dd/mm/yyyy.
  2. Save changes.

Sorting

  1. Click on the Pencil Icon Report-Fields-Pencil.jpg on the right of the Field. The Sorting Order field is populated with a drop down for all fields. Report-Fields-Sort.jpg
    Selecting the sort order of either Ascending or Descending for a field will cause the report to output the data in either an Ascending or Descending order highest to lowest.
  2. Save changes.

Condition

Conditions are used to filter your report based on a criteria.

  1. Down the bottom of the Fields SubTab there is the Condition section.
  2. Select the field you wish to filter by.
  3. Select the filter type. The filter type varies depending on what field you are filtering on.
    The most common are Equals To, Not Equals To, Is Last, This Last, Is Next.
  4. Select or Enter the value you are filtering on.
  5. For more than one Condition an AND or a OR operator can be selected.
  6. You can select multiple results for some fields by clicking on Options (if available) as shown below. Report-Fields-Options.jpg
  7. To group Condition clauses together, brackets can be used. This is done by clicking on the Greater Than icon Report-Fields-Bracket.jpg to the right of the Field in the Condition clause. Clicking on the Less Than icon will remove a Bracket.
    The below Condition clause can be written as:
    IF (Leaver = No OR Last Day of Work is Last Week) AND Department=”???list of Department???Report-Fields-Done2.jpg
  8. Save changes.

View Report

The View Report TAB allows us to generate and view the report. We can export to PDF or Excel file formats.
Only reports that are 'Grouped by can generate a Graph, otherwise a plain table of results will be generated.

  1. Select the View Report SubTab.

Report-View1.jpg Report-View2.jpg

Graph Types

The Graph type option will not be shown if a report has not been Grouped by. Selecting a Graph type will change the graph drawn on the report.

Graph Record Count

Selecting the Graph Record Count will show the number of records being reported on. Report-View-RecCount.jpg

Export Options

Selecting an Export Option and then selecting the Export link will cause the report to be exported into the chosen format (Excel, PDF, etc).

Do Not Export Graph

Selecting this checkbox will cause the graph to be excluded when exporting the report to the chosen format.

Subscribehr logo.gif