
Statement formats in use (open matters)
If you need to ensure control of your billing process and statement formats, I highly recommend a monthly report review of open matter...

Year End Vendor Contact Cleanup
One of my favorite firm leaders recently asked me for a ProLaw report she could run to identify which vendors have become inactive in the...


Toggling Date Field Format in Events Reports (Auto Show Time of Day)
The default field for event date for dockets is SQL datetime which appends midnight onto the day for any docket that is set as an all day...


XML Path Function Delimiters for ProLaw Data in Cascades
One of my favorite methods of extracting cascade information from ProLaw is using the XML PATH() function in SQL. The XML Path function...

Who is marking dockets complete?
If you have events audit trail turned on you can use the SQL code below to create reporting metrics (last 30 days) on who, and how many,...