Edit - Reports Menu

Copy

If you wish to copy a portion of the report into another document, click and drag to highlight the area you want to use.  Then select Edit / Copy from the menu.  This copies the specified data onto the Windows Clipboard.  From there it can be pasted into the document of your choice.

 

Select All

Select All is a simple way to highlight the entire report.  This is the simplest way to select the data so you can include all of it on a chart.  

 

Instead of using the click and drag method, select Edit / Select All from the menu.  The entire page can then be copied to the Windows Clipboard for later use, or you can quickly create a chart from your data by immediately selecting Chart from the menu bar.

 

Adjust Column Width

This menu item works like a toggle switch.  Clicking it the first time makes the column widths adjustable and places a check mark next to the menu item to indicate this.  While activated, you can adjust the column widths by clicking on the right edge of the header of any column and drag it to the right to widen or left to narrow the column.  When done adjusting the columns, click Edit / Adjust Column Width again to stabilize the columns and remove the check mark.

 

Hide Column(s)

Columns can be hidden by selecting them, then selecting Edit / Hide Columns from the menu bar.  You can select columns in any of the following ways:

  1. To hide one column, click anywhere in the column.

  2. To hide two or more adjacent columns, click and drag your cursor across the desired columns.

  3. To hide selected columns, hold down the [Ctrl] key and click in  each of the columns you wish to hide.

 

Why hide columns?

These reports are quite wide.  If only some of the information is relevant for a printed report, hide the column(s) you wish to exclude before you print the report.  This could save lots of paper.  Then unhide when  finished.

 

The same technique works with charts.  If you want to chart all but selected columns, hide the ones you do not want to appear.  Or, alternatively, hold down the control [Ctl] key and click only the columns you want charted.  Only selected columns are included on the charts.

Unhide Column(s)

To expose previously hidden columns, click and drag across the two columns on either side of the hidden one.  Then  when you select Edit / Unhide Columns, the hidden column will reappear.  If you don't know the location of the hidden column, click and drag the cursor across all of the columns, and then select Edit / Unhide Columns.  All hidden columns will reappear.

 

Sort

Selecting Edit / Sort from the Reports menu bar opens the Sort by Column dialog.  Here you can sort any or all of the data in the detail section of the report by any column(s) you choose.  

 

Why might you want to sort the data?  Because this allows you to generate more meaningful reports and charts.  For instance, your early Touch Key sessions all appear on the report along with later accuracy and speed drills.  To review progress during these latter sessions, it may prove useful to sort the report data into groups by type of session.  Next it would be more informative if these sessions were grouped by what type of decimal precision was required. And finally, within each of these groups, it might be useful to sort in session date/time order.

 

The main panel lets you Select Sort Key(s) in the order to be used in the sort.  It has three fields in it, each containing a drop-down list of the columns headers

 

First by:  Choose a data column from this list to be used as the primary sort criteria to be used in ordering the report. If the selected column has no duplicate values within it, it will control the entire sort process. The second and third level sorts below only serve to order results where the initial criterion is identical on more than one line.

 

Second by:  Choose a data column from this list to be used as a secondary sort criterion if the primary column contains identical values for two or more rows.

 

Third by:  Choose a data column from this list, if desired, to be the tertiary sort criterion if the primary and secondary columns both contain identical values in their respective columns for the same two or more rows.

 

Each of the above options also gives you the choice of showing the sorted rows in ascending or descending order.

 

The second panel allows you to choose whether you want to sort all of the detail rows, or only those you have highlighted by the click-and-drag method.

 

Click the OK button to close this dialog and sort the raw student data in order by the values in the (up to) three columns you selected.

 

The Cancel button closes this dialog without saving any changes you have made.