Estimated completion time = 15 minutes.

One benefit of EASA is that it allows authors to design the output from an EASAP to produce reports in any preferred format. We have already seen how to create a report in Excel format, but we can also create an HTML-based report for the output. The design of an EASAP’s output is performed on the OuUTPUT branch of the Tree in EASAP Builder. For the Stock Screener EASAP, you will 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 and open EASAP Builder.

To add a report,

• Right-click OUTPUT and select Child→Add REPORT.

Add the html file you uploaded in the beginning of the tutorial:

• Right-click report1and select Child→Add HTML OUTPUT. Rename it html_output_Report_Body and set:

We edit the report_body.html file using Template Editor.

• Select File→Save.

• Select html_output_Report_Body and 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 word ‘All’ within line 12 and replace it with choice_list_Exchange by double clicking the choice_list_Exchange DOR in the DOR List.

• Highlight the word ‘All’ within line 13 and replace it with choice_list_Sector in the same way.

• Highlight the word ‘None’ within line 14 and replace it with map_Query_Report in the same way.

At this point, you have added three (3) DORs to the template HTML file and the Template Editor window should look like the following:

Save the document

• Select File→Save and close out of the Template Editor.

• Return to EASAP Builder

• Right-click html_output_Report_Body and select Sibling→Add RESULTS TABLE. Set:

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

• Right-click results_table1 and select Child→Add DATA. Rename it data_Total_Stocks_Found. Set:

Now add a link to the Excel Spreadsheet.

• Right-click data_Total_Stocks_Found and select Sibling→Add DATA. Rename it data_Link_To_Spreadsheet_Report. Set:

Now we add a TABULATED DATA similar to the one within the USER INTERFACE branch. Before we do that we need to add a TEXT OUTPUT to display the heading for the TABULATED DATA.

• Right-click results_table1 and select Sibling→Add TEXT OUTPUT. Rename it text_output_Table_Heading and set:

• Copy (select, then type Ctrl-C) tabbed_pane_Stock_Screener→sub_pane_Search_Results→tabulated_data_Data_Output .

• Select OUTPUT→report1→text_output_Table_Heading and type Ctrl-B (Paste (Sibling)) to add the TABULATED DATA to the report.

The new TABULATED DATA object will be called tabulated_data_Data_Output1.

• Now save the EASAP, and then check the EASAP tree to ensure that the OUTPUT branch looks like the following:

You have now completed Practical Session 7 and you can exit out of EASAP Builder and then either proceed to the next session or take a break.

Practical Session 6 | Practical Session 8