The Data Grid

Overview

Data is presented in a grid located on the bottom half of the main screen of EZ-Scan. Each row of the grid represents one item in the database. Each column represents one data field stored in the database for that item. Each row is referred to as a record. Each column can be referred to as a field.

 

 

Column Positions

You can re-arrange the order of the columns in the grid. Click in the center of the column header and drag the column to the location desired. EZ-Scan will remember the order of the grid fields for you next time you run the program.

Column Widths

You can adjust the column widths by placing your cursor between two columns. Your cursor will turn to a double bar with arrows on each side. Hold down the left button of the mouse and drag to make the column larger or smaller. EZ-Scan will remember all column widths for you next time you run the program.

Sorting

You can sort on any columns by double-clicking on the header. The sort direction will reverse each time that you click on the header. First click will be ascending, next click will be descending. If you have a large amount of data in the grid it may take a few seconds to sort.

Editing

Double clicking on a record will open that item for editing.

Edit the item and click 'Save' to save your changes. The 'Enter' key will also click the 'Save' button.

Multi selecting items

You can select multiple items in the grid just as you would in Windows Explorer.

Hold the CTRL key while clicking to select non adjacent items.

To select a range of items select the first item. Scroll to the last item that you would like to select. While holding the SHIFT key click on the last item and all item between will also be selected.

To select all Click the square in the top left corner of the grid.

Right Click menu

Right click on the grid to get the following menu.

 

Grid Settings

This menu item will only be visible if you right click in the grid header.

Grid Font

You can change the font used in the grid using the ellipsis button next to the font text box.

Visible Grid Fields

You can customize the way the grid presents data on this screen. The grid on this screen presents you with all available fields from the EZ-Scan database. The checkbox on the right will allow you to show or hide the field in the main grid.

Grid color controls

Click on the color tab to get access to the color controls.

Click on the ellipsis next to each text box to set the color of the even and odd rows of the grid.

Restore default grid settings

You can change all grid settings back to the default settings by clicking the 'Default' button.

Edit Item

This will open the record for editing just as double clicking does, which was explained above.

Print

This will open the Print dialog box. See Printing Items for details.

Find

This will open the Find dialog box. See Locating Items for details.

Delete

This will delete all selected items in the grid. Hitting the 'Delete' key on your keyboard will do the same.

Select All

This will select all items in the grid. You can also hit CTRL + A or click the square in the top left corner of the grid to do the same.

Total

You can get a total of items in the same batch, of the currently selected items, or all the items in the grid. The total will be displayed in the status bar near the bottom right of the grid.

Find items from the same

This allows you to filter the items in the grid by Batch, Process Date, Company, or Group. The group option only appears if you have 'Allow Grouping of items' turned on. Once the grid is filtered, you will also have the option to 'Revert to last query'. This will remove the filter and show you all the items that were in the grid before the filter was applied.

 

Properties

This will display all the data in the database for  the current item in the grid.

 

 

Copying data and images to other applications

You can copy the selected data  to the clipboard and paste it into many other applications such as

To copy data in the grid select the items that you would like to copy and choose Edit>Copy or CTRL +C.

Choose Copy Data to the Clipboard from the Copy Dialog.

Then switch to the application to paste the data into and choose Edit>Paste or CTRL + V. This will paste the data to the other application.

 

Excel Example

 

Word Example

 

You can also copy the image and paste it into many image editing applications such as

 

To copy the current image in the grid  choose Edit>Copy or CTRL +C.

Choose Copy Image from the copy Dialog.

Switch to the application that you would like to copy the image to and choose Edit>Paste or CTRL + V

 

Word Example with image and data  pasted in the document

 

Paint Example