SPAR reports (module 4, pg 2)

Click on the Report tab and select Seedlot Reports and Seedlot Listing Report.

View sample Seedlot Listing Report screen

1. Select the report you wish to generate as Seedlot Listing Short Form or Seedlot Listing Long Form.
2. You must enter at least one of the following fields: Owner Agency, Specific Lot, Species, SPZ.
3. Enter any other fields that you wish to find results for. The more fields you enter, the more specific your report results will be.
4. Select the Export Format that you wish the results to be displayed in.
   • DOC for MS Word -- you will be able to edit the information.
   • XLS for MS Excel -- you will be able to edit the information.
   • PDF for Adobe Acrobat -- you will not be able to edit the information.
5. Click the Submit button.
6. This report allows you to view all Seedlots that correspond to the data you entered.

TIP: If you use the Short Form report it is important to note that if the Agency field is blank, and a Lot has more than one owner, the amounts printed will be the total for all owners. If the Agency field is filled in, and the Lot has more than one owner, the portion owned by that agency will be printed.

Click on the Report tab and select Seedling Request Reports and Seedling Request Short Form Report.

View sample Seeding Request Short Form Report Screen

1. Enter at least one of the following Request Status, Organizational Unit, Request Agency, Funding Source, Ministry Funded, Nursery Requested, or Nursery Assigned.
2. Enter any other fields that you wish to find results for. The more fields you enter, the more specific your report results will be.
3. Select the Export Format that you wish the results to be displayed in.
   • DOC for MS Word -- you will be able to edit the information.
   • XLS for MS Excel -- you will be able to edit the information.
   • PDF for Adobe Acrobat -- you will not be able to edit the information.
4. Click the Submit button.

If the report opened in the browser window instead of in a MS Word or an Excel file, follow these simple steps to copy the report information into a file on your computer. The steps for copying MS Word and Excel report information is the same.

1. Click your mouse button in the centre of the online report. (This tells your computer this is your active window.)
2. Press the Ctrl and A keys on your keyboard simultaneously. (This will 'Select All' of the fields in the report.)
3. Copy the information by either pressing Ctrl C or by right mouse clicking and selecting the 'Copy' function.
4. Open MS Word or Excel on your computer and paste the information by either pressing Ctrl V or by right mouse clicking and selecting the 'Paste' function.
5. Use the Save As feature in the MS Word or Excel application to name the file and save it in the appropriate location on your computer.

You will not be able to edit information if you download in PDF format but it may make it easier for you to print the information.

1. Once you press the Submit button Adobe Acrobat will prompt you to choose between opening the file from the current location or saving the file directly onto your computer.
2. Press the OK button.

Click on the Report tab and select Extracts and Seedling Request Extract for Non-Ministry.

View sample Seeding Request Extract for Non-Ministry screen

1. Enter the Sowing Year. This is a mandatory field.
2. Enter any other fields that you wish to find results for. The more fields you enter, the more specific your report results will be.
   • This report is only available in XLS (Excel) format.
3. Click the Submit button.

If the report opened in the browser window instead of in an Excel file, follow the "Downloading Report Information" instructions for XLS files listed above.