Estimated completion time → 15 minutes.

An Author may designate EASAP output in various report formats.

We have already seen how to create a report in an Excel format, but we can also create an HTML report for our output.

The OUTPUT branch of the Tree contains the objects which will render to HTML.

For the Stock Screener EASAP, we create a report that contains the following elements:

• Section displaying the search parameters
• Link to the Excel spreadsheet containing the desired stock data
• Table of stock data

Please follow the instructions below to complete this practical session.

• Select EASA→Set Mode→Author on the browser pages
• Select our 'Stock Screener' EASAP at EASA→Applications→My EASAPs
• Open EASAP Builder.

To add a report,

• Right-click OUTPUT
  • Select Child→Add REPORT
• Right-click report1
  • Select Child→Add HTML OUTPUT
    • Rename it html_output_Report_Body
      • Set→ File: report_body.html (uploaded earlier in this tutorial)

We edit the file, report_body.html using the Template Editor.

• Select File→Save or CTRL-s
  • Select html_output_Report_Body
    • Click on the Open Template Editor button () in the toolbar
      • (or from the menu bar: Applications→Edit Template…)

The Template Editor will start in a new window that looks like the following:

• Highlight the string “put inputbox Exchange here”
  • Replace it with inputbox_Exchange by double clicking inputbox_Exchange
• Highlight the string “put inputbox Sector here”
  • Replace it with inputbox_Sector in the same way.
• Highlight the string “put map Query Report here”
  • Replace it with map_Query_Report in the same way.

At this point, we have added three object references to the template HTML file.

The Template Editor window should look like the following,

Save the document:

• Select File→Save
• Close out of the Template Editor
• Return to EASAP Builder
• Right-click OUTPUT→report1→html_output_Report_Body
  • Select Sibling→Add RESULTS TABLE
    • Set→Table Style: Table

We want to display our count of all the stock symbols.

• Right-click results_table1
  • Select Child→Add DATA
    • Rename it data_Total_Stocks_Found
      • Set,
        • Title: Total Stocks Found
        • Value: %count_Symbol%

Let's add a link to the Excel Spreadsheet.

• Right-click data_Total_Stocks_Found
  • Select Sibling→Add DATA
    • Rename it data_Link_To_Spreadsheet_Report
      • Set,
        • Title: Results Output
        • Value: Open
        • Link to File: Results.xls

Let's add a TABULATED DATA similar to the one within the USER INTERFACE branch.

First, we add a TEXT OUTPUT to display the heading for the TABULATED DATA.

• Right-click results_table1
  • Select Sibling→Add TEXT OUTPUT
    • Rename it text_output_Table_Heading
      • Set,
        • Text: Table of Stock Data
        • Style: Heading 3
• Right-click tabbed_pane_Stock_Screener→sub_pane_Search_Results→tabulated_data_Data_Output
  • Select Copy (or CTRL-c)
• Right-click OUTPUT→report1→text_output_Table_Heading
  • Select Paste (Sibling) or CTRL-b to add a copy of tabulated_data_Data_Output to the report.
    • → The new object will be called tabulated_data_Data_Output1.
• Save the EASAP
• Check the EASAP Tree to ensure that the OUTPUT branch looks like the following,

We have completed Session 7, exit out of EASAP Builder and take a break or continue to the next session.

Introduction | Session 1 | Session 2 | Session 3 | Session 4 | Session 5 | Session 6 | Session 7 | Session 8