All reporting is done via ODBC connections and Crystal Reports
There are two ODBC connections available:
- The main database (
WOL_Prod) - The logs and stats database (
WOL_Prod_Log)
ODBC connections are configurable in Site Settings. But generally shouldn't need to be changed from their default.
Reports themselves have their connections remapped to the config settings. The convention is as follows:
- Any DSNs which do not start with
WOL_are not touched - Any DSNs which start with
WOL_and end in_LOGare remapped to the logs and stats database - Any DSNs which start with
WOL_and do not end in_LOGare remapped to the main database
The following common parameters are passed to every report:
| Crystal Name | Data Type | Sample Value | Comments |
|---|---|---|---|
| __ApplianceRootUrl | string | https://demo.wiseowllegal.com.au | Used to load a custom logo: combine with "/CustomReportLogo" |
| __CurrentUser | string | larry.lawyer | The current user name who is running the report |
| __ReportName | string | Trust Trial Balance | The name of the report as listed in the reports in Wise Owl Legal. Note that this may be different from the Crystal Report name. |
| __ReportId | integer | 8 | The report id which is being run. You can access additional information about the report via the table report.CrystalReport. |
Other parameters are passed based on view model data