ServerFile Reporting
3112_100822_7.png
If you are interested in how you can create nicely formatted reports and have them sent as emails you can take a look at the sample files and code that are available here.

How to Install
Download and expand the folder contained in RAD Reporting.zip

1. Create a New Message to Batch Admin and attach the 4 files (attach1, attach2, attach3 and attach4) to the message.
2. Open the Batch Script.txt attachment and copy and paste the text into the body of your message
Send the message to Batch Admin.
3. Place the FCASReporting.mdb source code and put in your FCAS source folder.




What Gets Installed
The batch script creates a conference in the "Clustered Services:FCAS Config" folder called 252008_42001_0.png.  This conference is aliased to the FCAS gateway desktop so that FCAS can 'see' it.  The script assumes that the gateway ID is the default 5000000000
Inside this conference are two other conferences
252008_42151_1.png
The Table cogence contains 3 html files that are used by functions that I have created that will allow you to build nice looking tables in code.
The Report Templates conference contains a single template document that looks like this.
252008_42340_2.png

Note that it is just a simple FirstClass Document that contains some variables that I have defined.

It contains stylized text and tables.


What the Application Does
The FCASReporting.mdb file is the source code that will make use of these template files and I have documented the source code so that you can see how you can use server files to build reporting templates.
There are no forms associated with the code and in the code I build some arrays to simulate a database of users and associated information.
When you run the application you are presented with 252008_42656_3.png
After Clicking on OK the code will use the template data and will build a table in code and then replace all variables in the template to create and send an email that looks like this.
252008_42806_4.png
Feel free to use my source code and enhance it for your own purposes.  I would really like to see a library of reporting routines like my table generator routines made available to other developers.