Predefined Reports & Graphs

This page provides an expanded description of what certain types of graphs are. These descriptions will assist you as you will know what types of data you will have to request in order for you to get the results that you are after.

Trend Graph

The Trend Graph allows you to see how the level of a single parameter has changed over time at a single monitoring location. You can choose to graph all historical samples for a parameter, or you can specify a time period:

Exceedance Graph

The Exceedance Graph enables you to determine, at a glance, whether a water sample from a single location complies with the Canadian Drinking Water Guidelines (CDWG). The page allows you to select the parameter results you want to graph and produces a graph for those parameter results.

Predefined Reports and Custom Reports

You can produce these reports in standard formats and download them as PDF (Adobe Portable Document Format) files to your computer for review and printing. In contrast to the reports you can create using the data results tool, you cannot use reports in PDF to create graphs and carry out customized statistical analysis.

Health authority employees will be the most frequent users of the predefined reports. For example, health authority staff might use the DW Bacteriological Report tool to monitor bacteria counts at EMS locations within their area of responsibility. However, ministry staff might also find such reports useful when they do not need the more comprehensive customization of the report that is available through the data results tool. 

The basic procedure for using the predefined reports has four basic steps. To create each report, you will:

  • Click on the report's button on the Main Menu
  • Enter report criteria into the Criteria page
  • Generate the report
  • Download the report to your computer

Examples Include:

  • Detailed Results Report
  • Historical Statistics Report
  • DW (Drinking Water) Bacteriological Report

Detailed Results Report

The Detailed Results Report allows EMS WR users to create a predefined report that displays detailed analytical results and a statistical summary for each parameter in the report. For example, you might use it to summarize sampling results for the year.

This report is most useful for results on a single monitoring site or a small group of sites. Reporting on a high number of monitoring sites can result in a large report. In this case, producing a custom report through the Data Results tool might be more appropriate if you need more detailed reporting.


Note, the images contained in this example are generic, and are applicable for all report types.  As this is the same tool, all reports will behave in a similar fashion.  

Historical Statistics Report

The Historical Statistics Report allows EMS WR users to create a predefined report that provides a detailed historical statistical summary for each parameter in the report. For example, you might use it to summarize sampling results for the year. 

This report is most useful for results on a single monitoring site or a small group of sites. Reporting on a high number of monitoring sites can result in a large report. 

DW (Drinking Water) Bacteriological Report

The DW (Drinking Water) Bacteriological Report allows EMS WR users to create a predefined report that summarizes bacteriological results for samples from drinking water sources. For example, you might use it to summarize sampling results for the year. 

This report is most useful for results on a single monitoring site or a small group of sites. Reporting on a high number of monitoring sites can result in a large report. Take note of the mandatory fields required for processing the reports. The reports will not run if all mandatory fields are not filled in.

Data Results Tool

The Data Results tool allows you to conduct sample result data searches of the EMS database based on a broad range of criteria, and to create customized reports of the search results. You can then download this report to your computer and analyze the data. For example, you might use the data for statistical analysis or to create graphs.

Government staff will be the most frequent users of the Data Results tool. For example, a ministry employee might want sample results data on all Cowichan Lake monitoring locations. Health authority staff might consider using the Data Results tool when the predefined reports are too narrow for their business needs. 

Basic Procedure for Creating Reports

To create a detailed results report:

From the Main menu, click on the appropriate button under the Reports heading. Enter information into the mandatory fields:

  • Collection Start Date
  • Collection End Date
  • Health Region (some reports only)

Enter information into the other Criteria Fields to narrow the scope of your search.  If desired, click the More button near the bottom right of the screen to see other options available. You might have to Scroll Down to see this button.

It is unlikely that you will want to change the Order By checkboxes from the default, however this option is available. For example, change the Order By from Date (default) to Sample State by removing the checkmark from Date and adding a checkmark to Sample State.

Once you have finished entering the parameters of your data search, click the Next button on the lower right hand corner of the page.  You may have to scroll down to view the button. The report Confirmation page opens.

Take notice of the name that EMS WR has given to your report. The name will include your username, and underscore, and a number (e.g. jsmith_2011). Note that if you are generating multiple reports within the same EMS WR session, the report numbers are not necessarily going to be sequential.  This is not an error.

If you are satisfied with the results of the report, click the Generate Report button.  After a moment, the page reloads (wait for Done to appear in the browser status bar).  if you want to create another report, click the Criteria button and return to Step 2.  Otherwise, proceed to the next step.

Click the Main Menu button. Click the List of Generated Reports button.  The List of Generated Reports page opens.


Note, the images contained in this example are generic, and are applicable for all report types.  As this is the same tool, all reports will behave in a similar fashion.  

Find the report you want to download and look at the Status column. If the report's status is Ready, proceed to step 11. If the report's status is Pending, you can try periodically clicking your browser's Refresh page, or (Reload Page) button to see whether the report is ready. Note that some reports can take up to several hours to create.

Click on the report to download it to your computer. Note: It might help you to install Adobe Acrobat Reader, and use it's functionality to help you Save or Print these reports.

Sample Reports

This shows a partial page capture of a Monitoring Locations Report opened with Excel: