In abstract, the application is required to do the following:
Connect to a specified SQL Server and retrieve its parameters and a list of available reports. These will be presented to the user, who will select a report to execute and additionally whether the session is to create messages to send by Email, or by SMS messaging.
The report will be executed and the resulting dataset will be used to create dynamic messages and recipients for those messages.
They will be displayed to the user in an editable grid, such that the user can make amendments and/or remove rows.
The user will submit the form, which will create and submit each message to a local SMTP server if emailn, or a remote server using SOAP (XML) for SMS messaging and log this to the SQL server.
More specifics are details in Advanced Details, attached.