Grid Toolbar

<< Click to Display Table of Contents >>

Navigation:  Professional > Navigation & Workspace > Grid View >

Grid Toolbar

Exports

Other Report Output

 

The grid toolbar appears for data grids within EQuIS Professional (which can display EQuIS tables, views, and grid reports).

 

grid_view_toolbar

 

Filter-Standard-32-green

Filter columns. Once enabled, select the Filter button or dropdown in a column to select specific values.

Pin(1)

Pin specific columns for easy data review when scrolling back and forth.

Column Chooser

Column Chooser to hide, unhide, or reorder columns.

15266-Table_and_View_Options

Font size chooser to temporarily change the grid display by selecting a font size using the dropdown menu.

Binoculars-02(1)

Search for information in rows and columns of tables using the Find and Replace Dialog. Click the icon in the toolbar, or use shortcuts Ctrl+F or Ctrl+H.

Reload(1)

Refresh tables to display recent changes, such as those made by loading an EDD or by another user.

 

Save-01

Save changes made to a table (not an option for Views, which only present query output).

Settings-32-green

Options to change the appearance of column headers and rows.

Notes

Toggle Notes Column, not available in Views.

Toggle Add New

Toggle Add New Box, not available in Views.

Data Delete

Cascade Delete, not available in Views. Deletes selected row(s) and all child rows in the database.

Data Find

Find All Child Records in the database, not available in Views.

Excel Export

Export to Excel for rows of the grid that are currently visible.

Export_32

Exports (see following section)

 

Exports

 

The Exports Export-16 button in the grid toolbar opens the Exports dropdown menu.

 

GoogleEarth32

Display in Google Earth (requires X_COORD and Y_COORD as row headers).

15266-expshape

Export Shapefile.

Outlook

Export to Outlook as an *.xls attachment in a message.

Print(2)

Send to Printer

PDF Export(1)

Export PDF

File Next-WF(1)

Export TXT, including the following Save as type options:

Tab Separated (*.txt)

Comma separated (*.csv)

HTML (*.htm)

JSON Schema/Data (*.json) - This is the concise JSON format typically used in Enterprise widgets that lists the columns once, then lists each row as an array of values.

JSON Table (*.json) - This is a more verbose JSON format that lists each row as an object with properties.

Compressed Data Table (*.cdt) - This is a compressed, binary format (not human-readable).

Access(1)

Export to Access as an *.mdb file.

15266-expxml

Export to XML. If exporting to XML for the purpose of importing through EDP to an EQuIS database, review this Known Issue forum post.

Check Mark(1)

Open Export toggle; deselecting this option prevents exports from opening automatically once created.

 

Other Report Output

 

Graph-01

Create an XY Chart

Graph-XYZ

Create an XYZ Chart

Trend

Create a Trend Chart

RDL-32

Create a RDL Report

Crosstab-Windows-08-WF(32)

Create a Crosstab Report

R Project

Launch and export to RStudio