As mentioned in the introduction, the System consists of 3
parts: the Data Transfer application, the report, and the Enterprise Server to
schedule and manage reports.
The data transfer application needs to ftp an xml file from
the server. Then we use a DTS package to import the xml file into a table in
SQL Server. This table is what the Crystal Report uses as the data source.
The Crystal Report uses a graph and some drill down.
Business Objects Enterprise server is utilized to send this
report once a month. Also, it tracks if this is a successful send or not.