Skip common site navigation and headers
United States Environmental Protection Agency
Begin Hierarchical Links EPA Home > Water > Wetlands, Oceans, & Watersheds > Monitoring and Assessing Water Quality > STORET > Data Owner's Corner > System Updates > STORET Reports 2.0.1 End Hierarchical Links


STORET logo STORET Reports version 2.0.7


STORET Reports version 2.0.7 is now ready for download and installation. Reports 2.0.7 is an upgrade to version 2.0.6 distributed earlier, and will enable retrieval of stored document graphic objects within several reports. This version 2.0.7 upgrade incorporates all of the improvements previously released as versions 2.0.1, 2.0.2, 2.0.3, 2.0.4, 2.0.5, and 2.0.6, and does not require them for its use.

The new feature(s) in this release: Location Reports Menu, File Exports, (Web Default) Reports
The Characteristic Range parameter provides the ability to define range/tolerance values for SELECTED Characteristics. These Range Values are interrogated against Result Values to retrieve data within the defined range or outside the defined range; as in the case to identify outliers. This feature may also be applied by defining a single boundary limit to retrieve all data either above or below the limit. Ranges may be established for multiple Characteristics. Range Values must be numeric. Range Values for Characteristics that resolve to a textual result (e.g., General Observation (text), LifeStage (choice list), *Non-Detect) will not be used for evaluation.



Download RPT_2_0_7.EXE (6.19 MEG) Now

Quit Without Downloading File

You must have Oracle version 8i (8.1.7)® or higher and STORET Reports version 2.0.0 installed before you can install STORET Reports version 2.0.7.

This download is in the form of a compressed, self-extracting 6.19 MB file, named RPT_2_0_7.EXE. You should place it in a temporary folder, and double-click it to allow it to expand.

It will create a subfolder named "RPT_2_0_7", and will place 10 files and 4 subfolders in it, including a text README file, and a User Guide and a Reference Document for the Reports Module, both in Adobe Acrobat Portable Document Format (PDF).

You should print and read the README file in this folder, and follow the instructions you find there.

The README file describes three (3) steps to this install. The first is to download the self-extracting zip file, RPT_2_0_6.EXE. The second is a database modification step (DBSetup.bat) which may require the assistance of your Oracle Data Base Administrator (DBA). The third involve physically copying several files (Install.bat) into the STORET Reports operating directory. These copied files will replace the identically named modules which run the reports.

... The DBSETUP.BAT file will launch a Structured Query Language (SQL)*Plus session, provide connection to your STORET database, and execute the SRMUPDATE.SQL file which contains a series of SQL statements. Several rows will be inserted in the TSRRLIST and TSRPARM tables, and a new function "FLDSET" created in the STORET1 schema. A log file named SRMUPDATE.LOG will be created as a record of the database transactions. Database Administrators that have applied different database names, user names, and/or passwords than those provided by default with the STORET 2.0 database will need to make alterations to the connection statements in the SRMUPDATE.SQL and DBSETUP.BAT files.
... The default forms and reports directory locations provided by the installation of STORET Report Module 2.0 are C:\STORET\STRRPT\FORMS and C:\STORET\STRRPT\REPORTS respectively. Custom installations of STORET Report Module 2.0 to different locations will require editing the "repdrive" variable found near the beginning of the INSTALL.BAT file.
... Be sure you complete all steps before attempting to test any of these changes. Once the files have been copied into the proper directory, your opening screen for the STORET Reports Module should reflect the new version number, v2.0.6.

Installation of this software takes only a few minutes.

To download this file, click the "Download Now" button at your left. To quit without downloading, click the "CANCEL" button.

For Troubleshooting Document/Graphic Button Retrieval Errors: Consult readme.txt and download an Update to Oracle 8i Client Package with required Oracle Provider for OLE DB Components node. Click here to download "Oracle 8i Client package Enhancement".


Need Help? If you have a question, or are uncertain about this download,
please call STORET User Assistance at 1-800-424-9067,
or send us an email at


Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us