HearAid Version 5.0



Previous topic Next topic  


Previous topic Next topic  

There may be times when you just want to inspect the raw data tables, perhaps to filter, customise a view and print the data view directly without going to the effort of preparing a custom report in Explorer or an SQL query in Query

The Browse view allows you to do those things quickly and easily


The Toolbar:



Use Select Table to open the table you want to browse. To see a listing of all tables in the database, along with a description of their contents, select TABLE LIST from the drop-down list
Use the Enable Column Filtering button to activate column filtering (Show/hide the filtering buttons in the column headers)
Use Expand/Collapse Groups, when you have grouped the data by one or more columns, to expand or collapse all groups
Use Highlight Selected Row to highlight the whole of the selected row in the table
Use Auto Column-Width to force the program to adjust column width automatically, based on the size of the underlying data field
Use Duplicate to copy the current row into a new row. This is really useful when you are adding new codes or devices



Use Export Table to export the table into the selected format

Import Table

Use Import Data to import data from an XML or Binary file created by HearAid's export function


In addition to the toolbar functions, right-clicking on the table displays a pop-up menu offering more options:



Load All Records reads the entire table into memory. This may take a few seconds, but once loaded you will find filtering, sorting and grouping functions are much faster. On the other hand, if the table is large, with more than 15,000 records, you may run into memory constraints which slow things down again


Load On Demand causes the table to fetch data "just-in-time", which makes displaying and navigating large tables much faster


Best Column Fit analyses the first 200 data rows and adjusts column width for optimum display/readability (you should have Auto Column-Width off for this to work properly)


Customise allows you to hide columns from view by dragging the column header to the Customise box (screenshot below)





The Work Area:



Column order can be changed by dragging Column Headers to the required position
Filtering Data You can quickly filter the data to show only those records you want. In Load All Data mode, the drop-down box will list all available entries for that column




Click the Down Arrow button on the column you want to filter, then click the check box for each value you want to include
Filters can be set on more than one column. Once a filter has been set, the filter condition is displayed at the bottom of the grid
The filter can be cancelled in 3 ways:


1.Temporarily, by un-ticking the box. Tick the box to restore the filter


2.Completely by clicking on the X, or


3.Click the Down Arrow button on the column and choose (All) from the list


The filter can be further customised and saved for future re-use, by clicking on the Customise button




If Load on Demand mode is active, click on the (Custom...) item to create a filter



Sorting Data Click on a column header to sort the data by that column; clicking a second time will invert the sort order. A small grey triangle shows the sort direction. Holding down the Ctrl key while clicking column headers will sort by multiple columns
Grouping Data Sometimes you may want to group data so that one or more columns act as "subheadings". To group data, drag the column header you wish to group on up to the yellow band at the top of the grid. Click on the + button to expand/collapse a selected group, or click the Expand button on the toolbar to expand/collapse all groups




Printing the table Once you have filtered, sorted and grouped your data, you can send the resulting view to the printer by right-clicking the grid and clicking Print Table on the pop-up menu. Your grid will appear in a Print Preview window exactly as it appears on-screen...