Survey Results (by Survey Type)
Copyright © 2020 EarthSoft, Inc • Modified: 24 Feb 2020
Report Name: Survey Results (By Survey Type)
Report Type: Standard EQuIS Alive Report
Description: This report prompts the user to select the survey type of interest prior to opening, and uses this selection to determine the available parameters that display.
The parameters are based on the custom fields that were selected for the survey type. These fields come from RT_PARAMETER and are associated with the table as a group in RT_GROUP and RT_GROUP_MEMBER. The output is raw survey results with the custom field values also being returned.
Notes for Enterprise Use:
•Due to the custom nature of this report, publishing it to the database involves the special steps explained below. This is required for use of the report in Enterprise*.
oOpen the Survey Results (by Survey Type) Report in EQuIS Professional.
oIn the popup window that opens, select the desired Survey Type and check the option to "Publish Report As".
oUpdate the default report name as desired. A report of the selected Type will be published to ST_REPORT and ST_REPORT_PARAMETER. The ST_REPORT.REPORT_NAME column populates with the survey type value prefixed with "FB77486--" in reference to the report .dll assembly file.
•The EarthSoft.Reports.Library.77486.dll file must* be in the Enterprise bin folder for this report to run in EQuIS Enterprise.
File Name: EarthSoft.Reports.Library.77486.dll
Input Parameters: A selection made to customize the output of a report.
Note: * refers to hidden parameters.
Tables: DT_SUBFACILITY, RT_TAXONOMY, DT_SURVEY, DT_SURVEY_OBSERV
Database Type: SQL
Database Schema: Standard and Alive schemas required
Database Version: EQuIS 5.6.1 for Alive 5.6.1; EQuIS 6.1 for Alive 6.1
Data Requirements: Contact firstname.lastname@example.org for more information if no information is available.
Report Requirements: N/A
Output Type: Report grid with options for Excel and Crosstab
Example Output: View the following example.