Skip to main content

Location Summary Reports

Learn how to generate Location Summary Reports to pull sampling data across Industrial Users, outfalls, and date ranges.

Overview

Location Summary Reports pull sampling data for one or more locations into a single table you can review and export. You choose the locations, outfalls, date range, and exactly which columns to include — then generate the report and download it as CSV.

This is the reporting tool to use for surcharge and cost-recovery billing, or any time you'd otherwise export sampling results and reassemble them in a spreadsheet.


Opening Location Summary Reports

  1. Click Reporting in the left sidebar.

  2. Click Location Summary Reports.

The Reporting home page with the Location Summary Reports tile

The Report Configuration panel opens. You can collapse it once your report is generated to give the results more room.

The Report Configuration panel

Step 1: Choose locations and outfalls

  1. In Locations, choose one or more locations.

  2. In Outfalls, choose the outfalls to include. This field stays disabled until you've picked at least one location.

When more than one outfall is available, a Select All option appears at the top of the outfall list.

⚠️ Changing your locations clears outfalls that no longer apply. If you remove a location, any outfall you'd selected for it is dropped from the report.


Step 2: Set the dates

Under Date Type, pick one:

  • Date Range — set a Start Date, and optionally an End Date. Leave the end date empty to report on a single day.

  • Relative Date — enter a number and an interval, for example Past 3 Months. The range is calculated from today each time you run the report, so a saved relative-date report always returns current data.

⚠️ You can't report on future dates. Both date pickers stop at today, and the end date can't be earlier than the start date.

Reports filter on each sample's end date. A sample that started inside your range but ended after it won't appear.

Setting a date range

Step 3: Choose how results are laid out

Set Display Format:

  • Single Table — every location together in one table.

  • Separated by location — one collapsible table per location.

Choosing a display format

Step 4: Add your columns

Click + Add Column and pick a column type. Add as many as the report needs; remove one with the delete icon beside it.

Column type

What it shows

What you set

Sample Result

The measured value from a sampling event.

Analyte, Sample Result Units

Calculated Result

A value worked out from a formula, such as Daily Maximum or Monthly Average.

Analyte, Calculation, Calculated Result Units

Flow Data

A flow measurement.

Flow Type, Flow Units

A few things shape what's on offer:

  • Flow isn't in the Analyte list. To report flow, add a Flow Data column rather than looking for a flow analyte.

  • Flow Type and Flow Units filter each other, exactly as they do on a sample report configuration — pick a volume total and only volume units are offered, and the reverse.

  • Changing the analyte clears the units you'd chosen, because a different analyte may not accept them.

  • Sample Result columns for standard analytes take concentration units only. Mass and mass-rate units don't apply to a raw measured value.

Adding columns with analyte, calculation and units

⚠️ A report can cover at most 25 analytes. Past that, generating fails with maximum 25 analytes allowed.


What data a report includes

A report only reads from submitted sample reports.

Anything not yet submitted is excluded — a scheduled report still being filled in contributes nothing, even if results have been typed in. Retracted submissions are excluded too, so a report that was retracted and resubmitted is counted once, not twice.

⚠️ This is the usual reason data looks missing. If a result you expect isn't there, check that its sample report has actually been submitted before checking anything else.


Step 5: Generate the report

Click Generate Report. The button reads Generating... while it runs, then the results appear below the configuration panel.

Results are sorted oldest first, then by location A–Z.

If several results share the same date and time, each one gets its own row, so a column may look like it repeats a date. That is expected.

A generated Location Summary Report

Every report starts with Date, Location, and Outfall columns, followed by the columns you configured. A configured column is named for what it reports, using the unit's full name rather than its abbreviation — so choosing mg/L gives a column headed BOD5, Milligrams per liter Sample Result, and a flow column in gal is headed Flow Result, Gallons.

How values appear:

  • A non-detect shows as ND.

  • Values are converted into the units you asked for.

  • A blank cell means no value could be shown — either there's no result for that analyte at that date and time, or the stored units couldn't be converted into the ones you chose. Rather than display a number in the wrong unit, the report leaves the cell empty.


Working with the results

Each results table has its own toolbar:

  • Search — type a term and click Apply (or press Enter) to narrow the rows.

  • The location dropdown limits a combined table to one location.

  • Select Columns — tick only the columns you want on screen.

  • Download CSV — export just this table, as it's currently shown.

Results separated by location

Results are paginated 20 rows at a time; you can switch to 10, 50, or 100. You can also sort and reorder columns.

⚠️ Sorting, reordering and hiding columns changes this table only. The Download in One File and Download in Separate Files buttons rebuild the report from your configuration, so they always use the default order and include every column you configured. To capture the table exactly as you have arranged it, use the Download CSV icon in its toolbar instead.


Saving a configuration

Click Save to keep the current setup for reuse. Save stays disabled until the configuration is complete, so finish filling it in first.

Give the configuration a name that isn't already taken — names are unique across your organization, and reusing one returns a report configuration with this name already exists.

Saved configurations are shared with everyone in your organization. Load one from the dropdown at the top of the panel, or choose New Configuration to clear the form and start over.

Once a configuration is loaded, its name sits at the top of the panel with two controls beside it: a pencil to rename it and a red bin to delete it.

⚠️ Loading a configuration does not always bring back its columns. Check the column list after loading one — if it is empty, Generate Report stays grayed out until you add a column back. Flow Data columns in particular are not currently kept when a configuration is saved.

The saved configurations list

⚠️ Deleting a saved configuration is permanent.

Your configuration stays on the form if you navigate away and come back, but the generated results don't — run the report again to see them.

Naming a saved configuration

💡 Saved configurations don't yet capture every field perfectly. After loading one, check the Calculation on any calculated-result column, re-add any Flow Data columns, and confirm a relative date before you generate.


Exporting a report

Once results are on screen, two buttons appear below them:

Button

What you get

Download in One File

A single CSV containing every location.

Download in Separate Files

A ZIP file holding one CSV per location.

Exports are prepared in the background. The button shows Starting..., then Generating... while the file is built, and the download begins on its own when it's ready. Cancel Export stops it.

⚠️ Only one export at a time per organization. If a colleague's export is already running, yours won't start and you'll see only one export may be queued per organization. Wait for theirs to finish, or ask them to cancel.

A few limits worth knowing:

  • If the export takes longer than 3 minutes, it times out and stops. Narrow the date range or the number of columns and try again.

  • The download link stays valid for 60 minutes after the file is ready.

  • Exported files are kept for 30 days, then deleted.

To export a single location's table instead of the whole report, use the Download CSV icon in that table's toolbar.


Troubleshooting

Problem

Likely cause

What to do

A result you expect is missing

Its sample report hasn't been submitted, or the submission was retracted

Confirm the sample report is submitted

A row is missing near the edge of your range

Reports filter on the sample's end date

Widen the range so the sample's end date falls inside it

A cell is blank but a result exists

The stored units couldn't be converted to the units you chose

Set the column to the units the result was recorded in

maximum 25 analytes allowed

The report covers more than 25 analytes

Remove columns, or split the report

only one export may be queued per organization

Another export is already running for your organization

Wait for it to finish, or cancel it

a report configuration with this name already exists

The name is already used in your organization

Choose a different name

Save is grayed out

The configuration is incomplete

Fill in every field on each column

Failed to generate report

The configuration was rejected

Check that dates are set and at least one complete column exists

The export timed out

It ran past the 3-minute limit

Shorten the date range or reduce columns


Related articles

  • Configuring Flow Reporting and Entering Flow Data

  • Understanding Sample Reports and Statuses

Did this answer your question?