SPAR Reports (module 4, pg 2)

Seedlot Listing Report

The Seedlot Listing Report is used to extract general seedlot information including seedlot ownership balance information. This report has a Short Form and a Long Form. The Short Form report displays one line of information per seedlot. the Long Form displays multiple lines of information per seedlot including information on the amounts owned by each agency.

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

Seedlot Listing Report Dropdown

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.

 

Seedlot Request Short Form Report

The Seedling Request Short Form Report is used to provide seedling request information in an easy to read format. The results generated from this report display one line of information per Seedling Request. 

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

Seedling request short form request dropdown

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.

 

Downloading Report Information

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.

 

Seedling Request Extract For Non-Ministry Use Submission

This data extract is designed to allow non-ministry users to easily gather several pieces of information in a single report for the seedling requests requested by their agency or assigned to their nursery. Due to the number of columns of data in this report, it can only be run in MS Excel format. The information can be viewed or modified in Excel or imported into another application.

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

Seedling Request Extract for Non-Ministry dropdown

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.