Is it correct that scripts cannot be run from within Time Matters (ver. 10), but must be run on the SQL server through the Management Studio or some similar application?
(I'm trying to develop, as part of a disaster plan, the easiest practical way for someone to obtain up-to-the-minute listings of matters, client contacts, and upcoming events. If someone has an idea on this, I'd appreciate hearing it.)
Joseph Nierenberg Nierenberg Employment Law, PLLC Consulting – Litigation – Training Minneapolis, Minnesota www.nierenberg.com
I usually build Excel Applications with User form input screens for filtering for this type of thing.
It's user friendly way of reporting and gathering your data from the TM database with all the tools of Excel, minus the confusion of SQL management studio.
Michael W. Gaines Jr. Gaines Database ConsultingTime Matters CIC Florence, SC 29501 (843) 615-8084 mgaines@gainesconsulting.comhttp://www.gainesconsulting.com Proud Southeastern Affiliate of Eastern Legal Systems, LLChttp://www.easternlegalsystems.com
This is one of my blog postings back in February regarding this very topic. http://easternlegalsystems.com/blog/2012/02/data-reporting-calculations-oh-my/
I'm working on part two to this paticular topic as we speak. It will be a simple video tutorial on creating a saved query in excel of active cases/matters. It would certainly help you to some degree in accomplishing what you're looking for but not entirely due to the complication of querying events and other supporting record types that the video doesn't cover. It also will not cover building filter forms as that is a more advanced programming task. However, the video blog should give you an idea of how you could accomplish your goal and get you started.