Collect – Field Forms Report

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with Collect >

Collect – Field Forms Report

Report Name: Collect – Field Forms (example)

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

Dependencies: Licensed Collect Module

Software: EQuIS Collect, EQuIS Enterprise

Source: EQuIS Collect install

Language: English

Output Type: Report Grid1 or PDF

 

Description: The Field Forms report returns data for completed forms based on the chosen Collect Form Template. The records include the date, time, username of the submitter, and coordinates for the form submission, allowing this report to be used on the Collect Enterprise Map page. These coordinates are captured when each form is completed. The coordinate records are stored in the DT_GEOGRAPHY table and linked to the form by a shared ID value (DT_GEOGRAPHY.OBJECT_EUID and ST_COLLECT_FIELD_FILES.COLLECT_FIELD_FILES_ID).

 

Installation Instructions: This report requires a licensed EQuIS Collect module and the Collect Schema applied to the database. For use, this report should be published to the database. Download the EQuIS Collect xcopy zip from the community center, unblock the *.zip file, and extract the EarthSoft.Reports.Library.149680.dll file to the EQuIS Professional installation folder. For default installations, this directory is C:\Program Files\EarthSoft\EQuIS. The report will be available for selection once it has been published.

 

Overview:

The report includes a link to a PDF summary of the form’s data.

 

Tables: DT_FACILITY, DT_EQUIPMENT, DT_GEOGRAPHY

 

Report Parameters

Facility

Parameter for selecting the facility.

Template(s)

Parameter for selecting template(s).

Technician(s)

Parameter for selecting technician(s).

Date Range


Start

Start date parameter selection.

End

End date parameter selection.

 

 

Report Output

FACILITY_ID

TEMPLATE

FILE_NAME

FACILITY

TECHNICIAN

DATETIME

X_COORD

Y_COORD

COLLECT_FIELD_FILES_ID

REPORT

 

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