Oops.. I deleted documents from ProLaw
We've all done it at some point. Accidently deleted documents from ProLaw, only to discover there is no undo button! Not fun. Luckily...
Adding "code" to SSRS Reports, I finally get it....
I finally figured out how and when to use the code portion of SSRS reports. Basically, we need to write code when there is not a default...
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...
ProLaw Querying; Never Use Brackets. Unless you get an error message.
In every query box in ProLaw, this concept holds true. Always, always, use parentheses and never brackets. Until you get the error...
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...
I just want a report in Excel (ProLaw & SSRS).
If you've tried to write an SSRS report for ProLaw, and just wanted it to export directly to Excel and have the right column mapping,...
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,...
ProLaw Events Report without Duplicates
If you are frustrated with duplicate events under events reporting, contact us for custom data sets and reports that have removed this...
