Standard with LakeWatch

File Name: EarthSoft.Reports.Library.LakeWatch.dll

Dependencies: LakeWatch module installed and LakeWatch Schema applied

Software: EQuIS Professional

Language: English

Output Type: Report Grid1, Excel2

Description: The LakeWatch reports summarize and provide analyses for lake analytical and field data.

Installation Instructions: These reports require the LakeWatch Schema applied to the database. The reports will be available for selection following installation of the LakeWatch Module within EQuIS Professional.

Overview:

Reports

Database Reports added by the LakeWatch Schema

Basic Result Exceedance

Basic Results (Action Level Exceedance by EDD)

Basic Results (Action Level Exceedance)

Basic Results (Aggregate)

Basic Results (Most Recent)

Basic Results (Rollup)

Facility Basic Results

Facility Basic Results (Summary)

Database Reports modified/recreated by the LakeWatch Schema

Basic Results

Location Information

Location Parameter Exceedance

Location Parameters

Location Parameters (Most Recent)

Location Parameters (Rollup)

Warning: Applying the LakeWatch Schema may remove existing user reports and report customizations for reports that it modifies or recreates. Back up user reports of the above, such as by exporting user reports to XML files, prior to applying the LakeWatch Schema.

Class Reports (from EarthSoft.Reports.LakeWatch.dll)

Name	Output	Description
Burns TLI2	Excel	Burns Trophic Level Index Report, including the following sections: Percent Annual Change Burns Trophic Level Index Values and Trends Summary and Report Notes
Carlson TLI2	Excel	Carlson Trophic State Index Report, including the following sections: Percent Annual Change Carlson Trophic State Index Values and Trends Summary and Report Notes
Lake Annual Averages Report	Excel	Lake analytical results by layer (e.g. surface, epilimnion) and as a whole, averaged over a 12-month span.
Lake HVOD Report	Excel	Lake hypolimnetic volumetric oxygen demand (HVOD) data, including a table and chart of annual (starting in summer): - Average temperature - Observed Dissolved Oxygen Rate - Observed Rate, temperature-corrected to average temperature of the entire dataset - Regression of Rates (on the chart)
Lake Monthly Averages Report	Excel	Lake analytical results by layer (e.g. surface, epilimnion) and as a whole, averaged by month.
Lake N-Monthly Averages Report	Excel	Lake analytical results by layer (e.g. surface, epilimnion) and as a whole, averaged over the interval of months specified. The Saved Lake Analysis report parameter must have its DATA_SOURCE updated to refer to the Lake Sample List Report. Instructions are below.
Lake Results Report	Grid	Lake analytical result output showing SYS_LOC_CODE, date, depth, coordinates, results, and layer.
Lake Sample List Report	Excel	Crosstabbed lake analytical results by station, date, depth, and analyte.

Lake N-Monthly Averages Report Parameter Corrections

The Saved Lake Analysis report parameter in the Lake N-Monthly Averages Report looks for user reports of a defunct base report. For this report to work, an EQuIS administrator should update the report parameter to point to the Lake Sample List Report as follows:

1.Open the System Table ST_REPORT.

2.In the REPORT_NAME column, search/filter for:
Lake N-Monthly Averages Report

3.Right-click on that row and select Related Tables > Child Tables > ST_REPORT_PARAMETER.

4.Click on the + symbol that appears to the left of the row.

5.For the ST_REPORT_PARAMETER entry with PARAM_NAME = @user_report_id, change the DATA_SOURCE from
select u.user_report_id, u.name from st_user_report u inner join st_report r on u.report_id = r.report_id where r.report_name like '%lake__analysis' escape '_' order by u.name
to
select u.user_report_id, u.name from st_user_report u inner join st_report r on u.report_id = r.report_id where r.report_name like 'Lake Sample List%' escape '_' order by u.name

6.Save.

Saved user reports for the Lake Sample List Report can now be selected in the Saved Lake Analysis report parameter. This parameter must be populated to run the Lake N-Monthly Averages Report.

Tables: DT_BASIC_RESULT, DT_COORDINATE, DT_FACILITY, DT_FIELD_SAMPLE, DT_LOCATION, DT_LOCATION_PARAMETER, DT_MEASURE_DATUM, DT_RESULT, DT_SAMPLE, DT_TEST

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.

2Excel report output requires a valid Microsoft Excel license to view the output.