Table and View Options

<< Click to Display Table of Contents >>

Table and View Options

EQuIS Professional offers several options that allow viewing and exporting the data in EQuIS Data Tables. After opening a Data Table, the Tabular View can be easily modified.

 

List of 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-Insert Column Lef_01(32)

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.

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.

 

Example - Changing Appearance of Tables

 

To change the appearance of Key (required) columns in a table (red by default):

1.Click the Data Tables button Tables-Table (located in the Open group of the Home tab).

2.Select DT_FACILTY and click Open.oh

3.Click the Options button Settings-32-green.

4.Expand Appearances and Column Headers.

5.Click Key Column.

6.Scroll down, click ForeColor and change to Dark Green.

7.Click OK.

8.The Key column headers are now dark green.

 

Note-Memo(2)

Toggle Notes Column, not available in Views.

Command-Undo-Redo(2)

Toggle Add New Box, not available in Views.

Data delete-WF(1)

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

Data Find-WF(1)

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

Excel Export (1)

Export table contents to Excel.

 

Exports Drop-down Menu (arrow next to Export to Excel button)

GoogleEarth32

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

15266-expshape

Export as a Shapefile.

Print(2)

Send to printer.

PDF Export(1)

Export as a .pdf file.

File Next-WF(1)

Export as a text (.txt) file.

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).

 

Graph-01

Create an XY Chart.

XYZ-Graph-02

Create an XYZ Chart.

Graph-03

Create a Trend Chart.

RDL-To do bar-WF(32)

Create a RDL Report.

Crosstab-Windows-08-WF(32)

Create a Crosstab Report.

R-large

Launch and export to RStudio.