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.6


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



Download RPT_2_0_6.EXE (6.05 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.6.

This download is in the form of a compressed, self-extracting 6.05 MB file, named RPT_2_0_6.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_6", 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