Home
The Museum System
Business Intelligence
About ChadChad Petrovay is the Collections Database Administrator at the newly formed Musical Instrument Museum in Phoenix, Arizona. Coming from a background in both archaeology and instructional technology, he spent the last two years managing the collections database at the Walters Art Museum in Baltimore, Maryland, where he instituted web initiatives to increase exposure of the collection through Facebook, Google Earth and ArtStor. He holds a BA in Sociology/Anthropology from St Mary’s College of Maryland, and a Masters in Archaeology (Egypt, Near East, India) from St Chad’s College/Durham University.

Tag: Crystal Reports

Check, mate: Creating a checkbox in Crystal Reports

Museum checklists and databases use boolean values, but, currently, there is no way to graphically represent this information in Crystal Reports. Here’s a quick work around to display checkboxes. In this example we will create a graphical checkbox to display if the object record is set for public access.
(more…)

August 4, 2009
Statistics at a Glance Report

As corporate philosophy continues to integrate itself into museum administration, greater emphasis is placed on the quantification of staff activities. Thus, I often find myself in the role not only of Database Administrator, but also of bean counter. This tutorial outlines how to create a Crystal Report that provides statistics drawn from TMS. (more…)

June 23, 2009