Reports

All reporting is done via ODBC connections and Crystal ReportsCrystal Reports

Reports and Slots

Crystal Reports

This details conventions and requirements for developing Crystal Reports.

Crystal Reports Runtime v13 is being used on the Appliances themselves. Report development is being done in v14 on Stella.

Database Connections in Crystal

There are two ODBC connections available:

...

ODBC connections are configurable in Site Settings. But generally shouldn't need to be changed from their default in production environments.

Reports themselves have their connections remapped to the config settings. The convention is as follows:

1. Any DSNs which do not start with WOL_ are not touched
2. Any DSNs which start with WOL_ and end in _LOG are remapped to the logs and stats database
3. Any DSNs which start with WOL_ and do not end in _LOG are remapped to the main database

Parameters

The following common parameters are passed to every report:

...