Grid View and Toolbar

<< Click to Display Table of Contents >>

Navigation:  Professional > Navigation & Workspace >

Grid View and Toolbar

Options

Exports

Other Report Output

 

In EQuIS Professional, the data grid offers several options for viewing and exporting data in EQuIS tables or grid reports.

 

15266-table-and-view-options

 

Options

 

Filter-Standard-32-green

Enable filtering in columns. Click the Filter button Filter-Standard(1) in a column to select specific values.

Pin(1)

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

Column Chooser

Choose columns to hide or unhide.

15266-Table_and_View_Options

Select a font size using the drop-down menu to temporarily change the grid display.

Binoculars-02(1)

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

Reload(1)

Refresh tables to display recent changes.

Save-01

Save changes made to a table.

 

Note: Save is not an option in Views in EQuIS Professional. A View contains methods to review data, not to modify data.

 

Settings-32-green

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

Finds all child records in the database, not available in Views.

Excel Export

Export table contents to Excel.

Export_32

Exports (see following section)

 

Exports

 

The Export-16 button next to the Export to Excel button opens the Exports dropdown menu.

 

GoogleEarth32

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

15266-expshape

Export as a Shapefile.

Outlook

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

Print(2)

Send to printer.

PDF Export(1)

Export as a .pdf file.

File Next-WF(1)

Export as a text (.txt) file.

 

Save as type options include:

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 .mdb file.

15266-expxml

Export to .xml. Note that if you are 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 (deselecting this option prevents exports from opening, 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.