- Excel Desktop Client new !
This tutorial should take approximately 2 hours to complete.
An organization maintains one or more databases that contain information that a User frequently filters and queries; the User will eventually create and save a report.
Suppose have an additional requirement for a dedicated web application that allows an authorized User access from a phone, laptop or tablet in any location.
We further specify that a User be able to export his or her results to an existing reporting tool, in this example we use a Microsoft® Excel spreadsheet.
Let's develop an EASA application, or EASAP, that interacts with a database and a Microsoft® Excel spreadsheet.
The Stock Screening Tool EASAP allows a User to search a database of stocks.
A snapshot of the completed EASAP interface is shown below,
The EASAP user interface will include filters and queries to let a User refine a stock search within the database.
A User may store the results of a search in an Excel report.
This tutorial provides step-by-step instructions to Author the EASAP from start to finish.
As we build the application, think about how this could be applied to databases and processes which exist within your organization.
This tutorial is designed for use with an EASA Server that is running Windows. For a linux EASA Server contact our support personnel at email@example.com to receive a Linux version of the tutorial.
Below is a brief description of each file.
|Results.xls||MS Excel spreadsheet in which to store search results generated|
|Stock.jpg||Selection image or “thumbnail” for the EASAP|
|report_body.html||HTML template HTML for an EASAP generated report|
|EASAlogo.jpg||Banner image located within report_body.html|
|read_StockData.txt||Text file containing a SQL query to read data from the database|
We are ready to begin Session 1.