Bits and Pieces
Limit Clinical report by Status Code
I want to list all work entered in the last 24 hours for a referral practice we do work for. I mark the referral practice with 'MC' on the animals Status Field.
Use Reports -> DataMajor -> Ad-Hoc -> Clinical by Date
Here we have entered 2 day to list work done in the last 2 days (little bit of leeway in there depending when you run the report). You could of course specify exact days. We are including all work (excluding ana code 255 - Payments) - if you leave both start and end analysis code blank it will report on any activity on the record. The important bit is in the 'Restrict By' entry - use status rlike "MC" - this will limit the report to only cards with 'MC' in the status field.
As we used the '2 day' option on the dates, you can save this report as a stored report and run it as often as you want without worring about the dates.