Thanks Dick! Hopefully that will help... cross your fingers for me! ________________________________ From: The Museum System (TMS) Users on behalf of Richard Grant Sent: Sat 1/26/2008 3:06 PM To: [log in to unmask] Subject: Re: Putting dimensions in Crystal reports Hi David, We have a bunch of old reports that use the now-inactive dimensions fields in the Objects table, fields that were in use before a multiple dimensions capability was available in TMS. Rather than change those reports, we just run SQL queries every night that pick up the dimensions from a view and plug them into the legacy fields in the Objects table. I'm not suggesting you do that, but the queries below show you where to find them. We don't bother with depth as we only have a couple of 3-dimensional objects. Interestingly, the ObjectDimensions view picks up the data from another view called DimensionsFlat. Hmm. Dick Grant Update Objects Set ObjectWidthCMOLD = OD.Width From Objects O, ObjectDimensions OD Where OD.ID = O.ObjectID AND O.ObjectID <> -1 AND OD.Width Is Not Null Update Objects Set ObjectHeightCMOLD = OD.Height From Objects O, ObjectDimensions OD Where OD.ID = O.ObjectID AND O.ObjectID <> -1 AND OD.Height Is Not Null -----Original Message----- From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Aylsworth, David Sent: Friday, January 25, 2008 4:10 PM To: [log in to unmask] Subject: Putting dimensions in Crystal reports Has anyone here been able to write a report in Crystal XI that gives individual dimensions (height, width, depth) in inches for each object? Where are those individual fields? Has anyone successfully pulled them out? How are they linked? I can't even figure out what table they are in. Help!! Thanks, David David Aylsworth Museum of Fine Arts, Houston Registrar for Collections telephone: 713-639-7824 fax: 713-639-7780