Juliana,

Exhibition Titles will not display on the fact sheet if the “Displayed” field were not checked on each Exhibition Title. Unfortunately, I do not see any way to configure this under DB config or the authorities, and I can’t seem to manually edit them at all.

You can edit a Fact Sheet by choosing “Report > Factsheet > Display Current Selection”. This will open a word processor window and allow you to edit the Fact Sheet before printing it. (If you include an image, it will not display in the window, but it will print).

Hope this helps. If this doesn’t work for you, let me know which fields you typically include in your fact sheet, your current version of TMS, and I’ll probably be able to throw together a Crystal Report for you.

Chad Petrovay  |  Collections Database Administrator
MIM—Musical Instrument Museum | 4725 E. Mayo Boulevard  | Phoenix, AZ 85050
480.478.6000 main  |  480.478.6058 direct | 480.471.8690 fax  | www.themim.org<http://www.themim.org/>

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Juliana Kreinik
Sent: Monday, January 10, 2011 12:07 PM
To: [log in to unmask]
Subject: Fact Sheets (part 2)


Hello TMS Users,

A basic question: can Object Record Fact Sheets be changed/amended/edited in TMS 2010?

We have a small catalogue raisonne staff, and we used the Fact Sheets (in the Object Module) on a fairly regular basis in TMS 9.35 -- they gave us a simple, quick listing of our basic Object Record info.

We recently upgraded to TMS 2010, and the Fact Sheets have changed a bit.

Now, when we create Fact Sheets for single or multiple Object Records, we have a recurring problem: If an Object Record has more than one (Primary, or Alternate) title, the Fact Sheet lists EVERY title. Even when an Object record has 16 primary titles.

It seems that the multiple titles originate from exhibitions -- i.e., every time an Object is in an Exhibition, the Exhibition-Related Object title is then linked back to the main Object Record. So, one Object in our database was in 16 different exhibitions, hence we have 16 Primary titles for that Object. The titles are identical, however. So, when printing a Fact Sheet, we have the same Primary title listed 16 times.

Does anyone know if I can eliminate these multiple (Primary) Object titles from our Fact Sheets (other than manually editing them after the Fact Sheet is created)?

I am the staff member who most frequently fishes around with our Database Configuration and attempts to fix/adjust basic TMS issues, but I do not use Crystal Reports, nor does anyone else at our office. We don't have an in-house CR person.

I am hoping that someone might at least be able to give me an answer about whether we would have the ability to edit the way Fact Sheets pull information from Object Records, and then perhaps tell me where I can turn for help with next steps...

Many thanks in advance!

Juliana Kreinik
Researcher
The Hans Hofmann Catalogue Raisonne Project
400 West Broadway, 3rd Floor New York, NY 10012