Bull Trout Effect and Take Reports deliver scalable canned reports by core area, local population or designated critical habitat waterbody and a robust Ad Hoc report building tool. The output products are primarily intended to assist field offices with analyses of consulted-on effects, and can be found in the TAILS Reports tab. Under the Section 7 Take/Effect Reports section, select the Bull Trout link. This will take you to the Bull Trout Effects/Take Reports selection page where you will find three tabs: Canned Reports, Ad Hoc, and Supporting Tables. Currently, we have the ability to report data in a tabular format only.
To view the Bull Trout Effects-Take report tools, click on the Reports tab in the TAILS modules menu (top of screen). On the Reports selection menu (found on the left hand menu and also the main body), under Section 7 Effect/Take Reports, select the Bull Trout link. This will take the user to the Bull Trout Take/Effect Reports selection page.
Note the warning under the Bull Trout Effects/Take Reports header indicating that reports may contain incomplete data sets. This will ultimately be resolved by the completion of historic data entry and required real-time effects and take data entries.
The Canned Reports feature exists to simplify output of some standard reporting needs. On the Bull Trout Effect/Take Reports page, select the Canned Reports tab. On the Canned Reports Selection page currently features the following report options: Run for Core Area, Run for Population Type, and Run for Critical Habitat Waterbody.
The report selection tool consists of one to three tiered drop down lists depending on which report you choose to run. Simply select the units you are interested in and then select "Run Report."
Note: When unit name indicates the selection was "merged" or "split", you must select the new units to retrieve data. Selection of these units will return no data, giving the false impression that no data exists for the unit. For example, do not select "Malheur River (split into Upper Malheur and North Fork Malheur)"; rather select "Upper Malheur" and/or "North Fork Malheur" form the list. These units were retained in the selection list to support cross-reference of legacy unit naming conventions and entry of legacy data.
All reports feature a standard title followed by the encompassing selected unit and report run date. Each report also contains five sections identified in the Contents, and up to five tables, depending on the information requested. The Contents include Consultation Summary, Species Effects, Critical Habitat Effects, Take Determination and Notes, and Take Measures. Selecting any one of these elements under Contents will take you directly to the desired table, or you can use the scroll bar to move through the report. Each table also has a scroll bar if needed to support the data output.
Each table includes the TAILS Activity Code in the first column. Selecting the Activity Code in any table will take you to the TAILS Core Information Page for that record. The data presented in each table can be sorted by headings in blue text; so for instance you can sort the Section 7 Consultation Summary table by Staff Lead.
Features and contents unique to the Section 7 Consultation Summary table include a “View” link to the Bull Trout Effect/Take summary page for the TAILS Activity, and the TAILS project title, project description, start and conclusion dates, and staff lead. All of this data is collected from the TAILS Core Information Page, and represent the complete set of TAILS projects contained in the report. Lastly, under each table are standard tools for saving to CSV, Excel, and PDF file formats.
If you run a Core Area or Population Type report, the next table in the output will include Bull Trout Effects-Take Species Effects data for the selected area. Each row in this table represents a unique Species Effect Instance. Therefore, there may be one to several rows of data representing each Action/Work Type indicated for a single TAILS Activity. Features of the Species Effect table include TAILS Action/Work Type, whether the effect instance is associated with an interrelated or interdependent Action/Work Type, Effect Type (Pathway and Indicator), and effect instance details: magnitude, frequency, start date, duration, and life stage(s).
If you run a Core Area or Critical Habitat Waterbody report, the table that follows the Species Effects heading in the output will include Bull Trout Effects-Take Critical Habitat Waterbody Effects Instance data for the selected area. Each row in this table represents a unique Critical Habitat Waterbody Effect Instance. Therefore, there may be one to several rows of data representing each Action/Work Type indicated for a single TAILS Activity. Features of the Critical Habitat Waterbody Effect table include TAILS Action/Work Type, whether the effect instance is associated with a interrelated or interdependent Action/Work Type, Effect Type (PCE and Aspect), and effect instance details: magnitude, frequency, start date, and duration.
If you run a Core Area or Population Type report, the two tables that follow the Critical Habitat Waterbody Effects heading in the report will include Take data entered into Bull Trout Effects-Take. The first table contains the Take Determination information and the second table contains specific Measure Level Take data. The Take Determination Table indicates the Take Determination and start and end data for the take associated with each TAILS Activity recorded with Bull Trout Effects-Take data for the selected area.
The Take Measure table includes the specific detailed take information collected in Bull Trout Effects-Take. Each row in the table represents each instance of take reported for each TAILS Activity in the selected area. Data in this table includes start, an end date or indication of whether the take was perpetual, take measure type, indication when the "There Will Be Take But It Is Not Quantified" checkbox was checked, specific lethal and/or sublethal take, and appropriate units of take.
The Ad Hoc tab on the Bull Trout Take/Effects Reports page allows users to navigate to the ECOS Reporting Server, also known as the Jasper Reporting Server that has been set up for the Bull Trout Effects-Take application. Users can create, manipulate, and save report queries (like a canned report) in several formats within this tool.
Selecting the Ad Hoc tab will take the user to the Data Chooser Source Topics Page. On this page the user will select a Topic. The TAILS folder contains a list of report pre-established topics, such as Bull Trout Species Effects Ad Hoc; each of which contains a specific subset of available Bull Trout Effects-Take data fields. Simply chose a topic and then identify which type of format; users will typically select Table format. Selecting a topic and format will take the user to the Ad Hoc View interface.
The ECOS Reporting Server Ad Hoc View interface includes a number of features. It is unrealistic to present a full explanation of the Jasper features and functionality here in this user manual. We have provided training to introduce Bull Trout Effects-Take users to this interface. It is highly recommended that users attempt go the following link for detailed help: http://help.jaspersoft.com/js-help-v5-en/.
Hint: Users can go directly to the Jaspersoft reporting server directly without a password requirement by following this link: https://ecos.fws.gov/jasperserver-pro4/ .
If the fields for the listed topics do not provide for the combination of data you are interested in, users can create their own data set by selecting Domains on the Data Chooser Source page.
The Data Chooser allows you to create combinations of available fields for selection on the topics page. First select fields, then select format, such as table. This will take you to the Ad Hoc View page where you can create reports. Again, follow the Jasper Help link for detailed help: http://help.jaspersoft.com/js-help-v5-en/ on creating new data sets.
Note: Read the Topic and Domain descriptions after selecting those items in the Data Chooser dialog to help you understand which Topic/Domain to choose.
Saving Ad Hoc reports can be done within Jasper (in addition to the CSV, Excel, and PDF download features provided). It is useful to save reports in Jasper because then you can avoid having to recreate common reports; essentially establishing a draft canned report that can be further customized for specific needs at a later time. To save a report, on the New Ad Hoc View tool bar on the main body of the Ad Hoc View interface, select the Save button then either “Save Ad Hoc View” or “Save Ad Hoc View As” (preferred) or “Save Ad Hoc View and Create Report.” You are required to name your report by filling in the Data View Name field, and you may also add a Data View Description if you like. Then select Organization, Reports, Workspaces, and Region 1 (or 6 or 8), and then the appropriate Field Office Name. Click the Save button and your report will be saved along with others created previously. Again, follow the Jasper Help link for detailed help, http://help.jaspersoft.com/js-help-v5-en/ , with saving reports in the repository.
To view or retrieve a report saved in Jasper, select the View drop-down list, located at the top of the Ad Hoc Editor Interface, and selecting one of the saved reports from the main body of the Repository page. Select “Repository” from the View pick-list. On the Repository page, select Organization, Reports, Workspaces, and Region 1 (or 6 or 8), and then the appropriate Field Office Name and your report will be listed along with others created previously. Again, follow the Jasper Help link for detailed help, http://help.jaspersoft.com/js-help-v5-en/ , with saving reports in the repository.
Note: If you create an Ad Hoc View or Report you would like to be protected from editing and/or elevated to an official Bull Trout report, please contact the ECOS help desk and they can restrict editing access to the report within your Office's folder or move the report location within the Jasper Report Server to the folder with other, official TAILS reports.
The links under the Supporting Tables tab of the Bull Trout Take/Effects Reports page allow you to view data field definitions. This tool will primarily be used to troubleshoot issues relating to biological unit relationships, so will not be needed by most users.