Subject: | |
From: | |
Reply To: | The Museum System (TMS) Users |
Date: | Sun, 27 Jan 2008 21:05:44 -0600 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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
|
|
|