Firepro2 has many reports; these have been requested and customized throughout the years by Fire Departments across Canada. However sometimes, the exact information you are looking for isn’t available in a report format- but you know the information is contained within the module. There is a simple solution to compile the information, and save it for later use. The export function is the best way to fit a lot of data from a module on a single page through exporting to Excel. (Another option is Scroll Reports, however not all the fields in a module will be available.)
In the following example a report is needed to see Fit Testing for each firefighter.
In the Personnel List window, list out the firefighters that you need to track. Click the Export button which appears as a green downward pointing arrow () found to the right of the Personnel list.
Choose ‘Export Personnel Fit Testing’ from the Export drop-list.
In the ‘Choose fields to Export’ window, the “All Fields" list expands each section for a list of available fields for that section, and allows you to drag and drop any data you wish to include on the report from this list to the ‘Chosen Fields for this Export’ list. For this example, I selected to include on the spreadsheet: First Name, Test Date, Full Mask Type, Full Mask Test Done, Half Mask Size, Half Mask Type, and Half Mask Test Done. The order of these fields will reflect the final order of the columns in the spreadsheet. The heading order can be changed by dragging and dropping in the ‘Chosen Fields for this Export’ list.
Select the desired export format with the following radio button options:
This is a text format where each piece of information is separated by a comma.
This is a text format where each piece of information is separated by a tab.
The user can select the symbol to use to separate the columns.
XLS and XLSX:
These are old Microsoft format and new Microsoft Excel format respectively.
The default Excel file type can be set by each user in File--> Preferences-->Report Preferences with the ‘Excel export form’ radio buttons.
If you find that you will do this kind of export more than once, you can save the template by clicking the add (+) icon under ‘Templates’ at the bottom of the window and naming the Template (and providing a description, if you wish.) This will allow you to recreate the same spreadsheet without doing it manually.
Save the Template changes with the checkmark icon at the top of the window.
Right-clicking anywhere in the bottom half of this window and selecting ‘Update Current Template’ will allow you to update any changes you’ve made to this Template.
Export your data:
Click the downward pointing arrow to export the data. You will be given a location box to save your file and give it a Name. The spreadsheet will now be available on your computer in the location you saved it.
Export Report- Personnel Fit Testing