Grid Toolbar in Professional

<< Click to Display Table of Contents >>

Navigation:  Professional > Navigation & Workspace > Grid View >

Grid Toolbar in Professional

Exports

Other Report Output

 

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

 

PRO_Grid_View_Toolbar

 

PRO_Filter-32

Filter columns. Once enabled, select the Filter icon or drop-down in a column to select specific values.

PRO_Column-Chooser-32

Column Chooser to hide, unhide, or reorder columns.

PRO_Pin-32

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

PRO_Font-Size-Chooser

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

PRO_Find-32

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

PRO_Refresh-32

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

 

PRO_Save-32

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

PRO_Settings-32

Options to change the appearance of column headers and rows.

PRO_Notes-Toggle

Toggle Notes Column, not available in Views.

PRO_Toggle-Add-New-Box

Toggle Add New Box, not available in Views.

PRO_Cascade-Data-Delete-32

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

PRO_Find-Child-Records-32

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

PRO_Excel-Export-32

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

PRO_Export-32

Exports (see following section)

 

Exports

 

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

 

PRO_GoogleEarth-32

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

PRO_Export-ShapeFile

Export Shapefile.

PRO_Outlook-32

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

PRO_Print-32

Send to Printer

PRO_PDF-Export-32

Export PDF

PRO_Text-File-Export-32

Export TXT, including the following Save as type options:

Tab Separated (*.txt)

Comma separated (*.csv) – All quoted: All the values are quoted.

Comma separated (*.csv) – Text quoted: Only text values are quoted.

Comma separated (*.csv) – None quoted: No values are quoted.

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

PRO_Access-Export-32

Export to Access as an *.mdb file.

PRO_XML_Export-32

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

PRO_Open-Export-32

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

 

Other Report Output

 

PRO_Graph-XY-32

Create an XY Chart.

PRO_Graph-XYZ-32

Create an XYZ Chart.

PRO_Trend-32

Create a Trend Chart.

PRO_RDL-32

Create a RDL Report.

PRO_Crosstab-32

Create a Crosstab Report.

PRO_R-Project-32

Launch and export to RStudio.