Versions Compared

Old Version 16

changes.mady.by.user Jessica Clark (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Gemma Heidemann

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

There are two ODBC connections available:

  1. The main database (WOL_Prod)

  2. 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 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 _LOGare remapped to the logs and stats database

  3. Any DSNs which start with WOL_ and do not end in _LOGare remapped to the main database

Parameters

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".

__ApplianceDnsName

string

demo.wiseowllegal.com.au

The same as __ApplianceRootUrl, but without the https:// at the start. Useful to identify an Appliance on a report. 

__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. 

__EnvironmentName

string

PROD

This will mostly be set to PROD, unless a client has a testing or staging Appliance configured. It is the name which appears in the top yellow warning bar. 

__ServerName

string

ALDRINGTON

This is the server name of the machine the Appliance is running on. It is generally not very useful as users do not see this name anywhere.

__ApplianceBaseDnsName

string

demo

The first part of the Appliance URL (the demo part in demo.wiseowllegal.com.au). This contains a short Appliance name. However, a larger client may have a customised Appliance URL such as wiseowl.bigfirm.com.au, so care must be taken.

Other parameters are passed based on view model data, ONLY when the report is assigned a to slot and the user clicks on the Print icon, base on the following rules:

...

  • Most pages which show a single record will have an ID property which relates to the primary key of a database table.

  • Any link which has a number right at the end of it has an ID property corresponding to that number.

Link

ID

/Report/edit/1

1

/Contact/Edit/1019/20

20

/Matter/Edit/14-1088/89

89

  • Pages which allow searching of records commonly have a Name property (and various others depending on the needs of the search page).

  • You can view the raw view model data by appending ?__ViewModelDebug=y to a page you load. This will show all the view model properties available; usually there will be enough there to pass to a report.

...

Shows the details of a trust receipt with all line items.

Crystal Name

Data Type

Sample Value

Comments

ID

integer

123

The transaction id of the receipt. This is the TrustJournalHeader.Id database field and TrustReceipt.TransactionId database field. 

IsOriginal

boolean

false

Set to true when the printed receipt is first printed. False when the receipt is re-printed from a transaction details page. Note that the database does not track when the report is actually printed to paper (as it can't reliably do that), so the value of this parameter is a best guess.  

Trust Cheque

A printed cheque. This can be printed from trust cheque and bank transfer transactions. It is recommended to just print the cheque portion of the transaction, no other details.

Wise Owl Legal accommodates printed cheques, hand written cheques, and where the local regulations allow electronic funds transfer (EFT) transactions. 

Crystal Name

Data Type

Sample Value

Comments

TransId

integer

123

The transaction id of the cheque or bank transfer. This is the TrustJournalHeader.Id database field and TrustCheque.TransactionId database field. 

ChqId

integer

76

The cheque id of the written cheque. Note that this is not the cheque number itself (because you can duplicate cheque numbers) but the TrustChequeWritten.Id field.   

IsOriginal

boolean

false

Set to true when the printed cheque is first printed. False when the cheque is re-printed from a transaction details page. Note that the database does not track when the report is actually printed to paper (as it can't reliably do that), so the value of this parameter is a best guess.  

Deposit Slip

Details of cash and cheques to be deposited at the bank.

Crystal Name

Data Type

Sample Value

Comments

ID

integer

123

The transaction id of the deposit. This is the TrustJournalHeader.Id database field. 

IsOriginal

boolean

false

Set to true when the deposit slip is first printed. False when the deposit slip is re-printed from a transaction details page. Note that the database does not track when the report is actually printed to paper (as it can't reliably do that), so the value of this parameter is a best guess.