TOPSpro Hot Tips and Tricks

Listers

• Right click on agency, site, student column header (not the filter box) to change sort order from name/ID to ID/name.
• To see lister data in report format click the print preview button.
• Clicking on the save icon in the lister window gives you the option of saving the lister data in an excel, lotus or text file.
• Checking the “No E/U/T/O” box and requerying will give you a list of your phantom records.
• Right clicking in any of the filter boxes will give you additional filter options.

Misc.

• Clicking on the Key icon on the tool bar brings up the log-in screen to change log-in names.
• Right click in the name field in an entry, update, or test record will open the student (demographic) record.
  In the student record, clicking the print preview icon shows all information for student across sites and years.
• Requery can also be done by using [F5] key.
• Information icon on each record gives you information on how it came to exist and if it has ever been modified.
• In the merge wizard, right click on a desired field in order to choose a value for selected student records.
• Highlight any line in a mover and type initial letter of the field that you want to move quickly down to that field.

Reports

• Always preview reports before printing.
• In Report Setup if you double-click on the number in the parentheses to the right of a category line then you can change to all without opening the mover.
• In Report Setup under the options tab, in the sorting boxes you can reverse the sort order by using a control click maneuver.

IMPORTANT STUFF TO REMEMBER

Help function [F1] is there to help you, so use it often!

Demos are available and there are more to come with each CD release so watch for them.

BACK UP YOUR WORK, BACK UP YOUR WORK, BACK UP YOUR WORK (on and off your hard drive)!

Don’t forget to pack and reindex.

Barbara Ralston, June 2004