Cross-Tab

<< Click to Display Table of Contents >>

EQuIS 7  >>  EnviroInsite > Reports >

Cross-Tab

The crosstab report transfers observation records from EnviroInsite Excel or Access databases to a two-dimensional Microsoft Excel table. A legend associated with the query is provided in the Excel file.

 

Crosstab_Report_Excel

 

To create a crosstab report, select Reports> Cross-Tab from the main menu. The RadForm1 dialog box opens. Modify the properties on the Query tab, Constituents tab, Locations tab, Style tab, Standard tab and Options tab as desired. Select the Generate Report button to create the crosstab report and open an Excel file. The dialog box stays open, which allows the query to be modified and the report re-run.

 

View a training video on creating crosstab reports in EnviroInsite here.

 

Query Tab

 

Crosstab_Report_Query_Tab

 

 

Constituents Tab

 

Select the desired constituents and click the >> button to move the constituents to the Selected pane.

 

Locations Tab

 

Select the desired individual locations and click the >> button to move the locations to the Selected pane or select the desired location group from the drop-down menu.

 

Style Tab

 

Click the radio button to select from one of the four pre-defined crosstab report layouts.

 

Crosstab_Report_Style_Tab

 

Standard Tab

 

Select from regulatory standards and set cell styles to indicate exceedances. Full color palates are available by clicking on the Crosstab_report_color_button button to open the Color dialog box.

 

Crosstab_Report_Standard_Tab

 

Options Tab

 

Enter the desired report titles and footer information. Select a date style format.