Creating a Custom SIBEC Report
The Custom Reports Web Application system consists of the SIBEC Custom Reports screen and three custom reports. The SIBEC Custom Reports screen provides the means to create the custom reports by selecting values from drop-down lists or entering values into data entry fields. A brief description of each Custom Report is outlined below:

The SISU Report By Region.
This report displays a page summary for each Region and Biogeoclimatic unit pair. This report lists each site series in the specific Region/Biogeoclimatic unit cross referenced with each Tree Species. Where a value exists, it is displayed. If a value does not exist, it is left blank. The Sample Size and Standard Error columns have coloured backgrounds to assist in distinguishing the columns from each other. The background colours will not show up on reports printed from the browser. If coloured columns are required in the printed version the Excel version can be downloaded and colour added to the columns as required.

The SISU Report By BCG Unit.
This report displays the Species for each Site Series and Site Association ordered by the BGC Unit. The report lists the Sample Size, Mean Site Index, and Standard Error. Data is grouped by BGC Unit, Site Series and Site Association and separated by a blank line.

The Site Association Report.
This report displays a summary of Site Association data and Tree Species. The report lists the BGC Unit, Site Series, Sample Size, Mean Site Index, and Standard Error of Mean for each Site Association and Species and precedes the amounts by the total values for all the BGC Units combined.

The first time the SIBEC Custom Reports screen is accessed, default values are set for the reports and parameters. The default report is the SISU Report by Region. All parameter drop-down lists and the Sample Size and Mean Site Index parameters are disabled.

To create a report, make a selection from the report drop-down list labelled "Select a Report:" and click the Update button alongside the selected value. The first available drop-down list for that report will be enabled with a value of All. This will be the Region drop-down list for the SISU Report by Region, the BGC Unit drop-down list for the SISU Report by BGC Unit and Species drop-down list for the Site Association report. The Sample Size and Mean Site Index parameters will also be enabled if a SISU Report by Region or SISU Report by BGC Unit were selected.

The value in the enabled drop-down list can be changed if required. To change the value click the down arrow on the right hand side of the drop down list and select a value and then click the Update button to the right of the value. The next drop-down list will become enabled. Whenever a value is changed in a drop-down list, whether it is the most recently enabled drop-down list or an earlier one, the Update button to the right of the drop-down list must be selected to ensure that the relationship between drop-down list parameters is maintained. The only exception to this is the Species drop-down list, which does not have an Update button.

The process of enabling drop-down lists, changing the value as required and clicking the Update button is repeated until all required parameters have been selected.

The Sample Size and Mean Site Index parameters are enabled when a SISU Report by Region or SISU Report by BGC Unit report is selected and the Update button is clicked. Values for the Sample Size and Mean Site Index parameters can be entered at any time after they are enabled. The Sample Size and Mean Site Index parameters do not have associated Update buttons. Choosing logical operators and entering values are the only steps required for the Sample Size and Mean Site Index parameters.

Once a report and required parameters have been selected the Report button is used to create a report. The Reset button is used to set all choices to their defaults.

The process of creating a custom report and downloading an Excel version of the report is detailed in the sections below.

Note: Each time a value is selected from a drop down list, except for the Species parameter, the Update button alongside the selected value must be clicked to ensure that the selected value and its associated parameters are used.

Step by Step Process for Creating a Custom SIBEC Report
  1. The first time this screen is viewed, or when the Reset button is clicked, the default values are set and the parameter drop-down lists and the Sample Size and Mean Site Index parameters are disabled.

  2. Select a report from the report drop down list.
    3.

  3. Click the Update button alongside the report drop-down list. A parameter drop-down list in the Select Parameters section is enabled. This will be the Region parameter for the Site Index Site Unit (SISU) Report by Region, the Biogeoclimatic (BGC) Unit parameter for the SISU report by BGC Unit and the Species parameter for the Site Association report. The Sample Size and Mean Site Index parameters are enabled if the SISU Report by Region or SISU Report by BGC Unit were selected.
    4.

  4. Select a value from the enabled drop-down list, or leave it at the default value of All, and then click the Update button alongside the chosen value. The next drop-down list parameter is enabled with list values related to the values in prior drop-down lists and the default value is set to All.
  5. Repeat the process in point 4 above with the remaining disabled parameters until all required values have been chosen.
  6. Values and logical operators for the Sample Size and Mean Site Index can be entered at any time after they are enabled, if required. It is not necessary to click an Update button when values or logical operators for the Sample Size and Mean Site Index are altered. If they are left blank then all values for these parameters will be returned in the report. Note: The Sample Size value, if entered, cannot be less than 2.

  7. Click the Report button to generate a report. A new screen will appear with the generated report. The report can be saved as an Excel file by using the "Download Excel Version" link at the bottom of the report page. To return to the SIBEC Custom Reports screen use the browser's back button or use the "Create another report" link at the bottom of the report page.
  8. To reset the parameter values to their default values click the Reset button.

Step by Step Process for Creating an Excel version of a Custom SIBEC Report
  1. Generate a report as detailed in the section "Step by Step Process for Creating a Custom SIBEC Report" above.
  2. Go to the bottom of the report page .
  3. Click the "Download Excel Version" link. A download dialog box will appear. Ensure that the "Save this file to disk" option is selected.
  4. Click the OK button. A "Save As" dialog box appears. Select a directory and then click the Save button to save the file. The file will download and then the dialog box will disappear.
  5. To return to the SIBEC Custom Reports screen use the browser's back button or use the "Create another report" link at the bottom of the report page.
  6. Note: The colours displayed in the Sample Size and Standard Error columns in the browser will not show up on reports that are printed from the browser. If coloured columns are required in the printed version the Excel version of the report can be downloaded and colour added to the columns as required.