Table and View Options

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Tables and Forms >

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.

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.