<< Click to Display Table of Contents >>

Navigation:  EnviroInsite > Reports >


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.




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





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.




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.




Options Tab


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