TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Aylsworth, David" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Sun, 27 Jan 2008 21:05:44 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (66 lines)
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 

ATOM RSS1 RSS2