Geotechnical Collect Report

Report Name: Geotechnical Collect Report (example)

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

Dependencies: Licensed Collect Module, EQuIS Geotech, and Geotech Schema

Software: EQuIS Collect, EQuIS Enterprise

Source: EQuIS Collect install

Language: Arabic, English, French, German, Portuguese, and Spanish

Output Type: Excel1

Description: The Geotechnical Collect Report exports data from the Geotech Schema and is primarily used for pre-populating data forms in Collect and the Web Forms widget.

Installation Instructions: The Geotechnical Collect Report requires a licensed EQuIS Collect module and a license for the Geotechnical_v2 format. It also requires the standard EQuIS Schema, Collect Schema, and Geotech Schema (from the same build, 7.23.2 or greater) applied to the database. For Enterprise use, this report should be published to the database, and when publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Overview: The Geotechnical Collect Report is used to pass information from the report to Collect Data Forms and Enterprise Web Forms widget using the pre-population feature.

Tables: AT_LOCATION, AT_MATERIAL, DT_COORDINATE, DT_DOWNHOLE_PARAMETER, DT_DRILL_ACTIVITY, DT_EQUIPMENT, DT_EQUIPMENT_PARAMETER, DT_FACILITY, DT_GEO_BACKFILL, DT_GEO_CORING, DT_GEO_DISCONTINUITY, DT_GEO_LAB_ASSIGN, DT_GEO_RESULT, DT_GEO_ROCK_FIELD, DT_GEO_STANDARD_PENETRATION, DT_GEO_TEST, DT_GEO_TEST_PARAMETER, DT_GEOGRAPHY, DT_LITHOLOGY, DT_LITHOLOGY_COMPONENT, DT_LOCATION, DT_LOCATION_PARAMETER, DT_SAMPLE, DT_SAMPLE_PARAMETER, DT_TASK, DT_TASK_PARAMETER, DT_WATER_TABLE, RT_COMPANY, RT_GEO_TEST_METHOD, RT_GROUP, RT_GROUP_MEMBER, RT_MATERIAL

Report Parameters

Task Code	Please select one task.
Location\Individual(s)	Please select one or more locations.
Location\Group(s)	Please select one or more location groups.
References\Equipment Type(s)	Please select one or more equipment types. The most recent equipment parameter values will also be exported for the selected equipment types. Note: Only selected types will be exported.
References\Company Type(s)	Please select one or more company types. Note: Only selected types will be exported.
JSON References\Company\Office	Please select the equipment type for the office. Note: Only selected types will be exported.
JSON References\Company\Lab	Please select the equipment type for the lab. Note: Only selected types will be exported.
JSON References\Equipment\Hydrometer	Please select the equipment type for the hydrometer equipment. The most recent equipment parameter values will also be exported for the selected equipment types. Note: Only selected types will be exported.
JSON References\Equipment\Drill Rig	Please select the equipment type for the drill rigs. The most recent equipment parameter values will also be exported for the selected equipment types. Note: Only selected types will be exported.
JSON References\Material\USCS	Please select the material type for USCS symbols. Note: Only selected types will be exported.
JSON References\Material\Graphic	Please select the material type for the material graphic. Note: Only selected types will be exported.
JSON References\Material\Type	Please select the material type for the material. Note: Only selected types will be exported.
JSON References\Material\Rock Type	Please select the material rock type. Note: Only selected types will be exported.
Output File Type	Please select the Excel file type (i.e., .xls or .xlsx) for the report output.

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