Project had Fun Stuff to do


While I'm still in the process of updating the service listings in the database, I had a 2-week respite from that, creating reports from the case management system. The fun part was using Crystal Reports to create the reports. The process involved downloading data from the system into Excel worksheets, then overlaying the spreadsheet with Crystal Reports.

This reporting method was vastly different from the reporting I had done in the past while a consultant -- in those days I used a DBMS language with reporting and procedural capability called Nomad. Crystal Reports is a GUI-based software that can be used for nearly every major ODBC database as well as Excel. The reports involved demographic data and case management system usage.

Note: Crystal Reports costs approximately $75 for a non-profit and is available from Tech Soup (or at least is was about a year or so ago).