Tim,
Not sure whether you could hook into the Real-time statistics in Symposium (in the way that wallboard software does). Your IT bods may know a way to do this.
As far as doing it from historical reporting goes......... It is possible but is time consuming and difficult to set up. You'd be looking at setting up 2 Symposium reports (1 for application data and 1 for login duration/agents online data) to run every 15 minutes. You can automatically import these into Excel with time coding (i.e. get Excel to pull in data just after report will have finished running in Symposium). If you have gone for the .xls file type you will need to build a module that works around the formatting put in by Crystal (I find a formula just to the right of the report works nicely). Alternatively the .tst file type is a lot closer in format to the old Meridian MAX, data streamed reports. It's a long-winded way to get to an answer but it does work.
An easier way for the historical stats method would be to obtain permission from your database administrators to allow you to link Excel into the database using ODBC. You could then just have a query set up to run every 15mins to pull in new data. The downside with this method is that you'll be connected to the live database and could, therefore, inhibit system performance.
HTH
|