Yes, point taken, but we've writen various 'big' reports in the
Exhibitions area. The sort of issue I'm refering to occurs when, for
example, somebody phones a Curator with a query about an object in the
process of being loaned-in to Tate and the Curator doesn't have an up to
date copy of the appropriate report to find the information they need.
For a big exhibition with 200+ loaned objects, scrolling down a list
sorted by an arbitary Object ID is time consuming - ditto Loan IDs. And
where the burden of entering all of this data in the first place falls
to the same Curators (an additioanl workload for them...) who can't get
the information back out, then frustration follows. 
 
At the moment, the Exhibitions module of TMS doesn't support the ongoing
activity of organising an Exhibition as well as it might. Possible
work-arounds include linking reports via a Media record and refreshing
these periodically, or scheduling reports to run nightly and serving via
intranet or, again, a Media record.
 
 
-----Original Message-----
From: David Parsell [mailto:[log in to unmask]] 
Sent: 06 December 2002 19:12
To: [log in to unmask]
Subject: Re: Sorting Object and Loan records within the Exhibitions
Module
 
 
If you write reports in Crystal Reports, you can sort TMS data almost
any way you choose.
 
Also, CR saves the messy work of exporting and manipulating the data in
excel since you can easily review the report on screen after you query
the appropriate data.
 
CR is extremely powerful. I rarely have the need to export TMS data for
manipulation in another program.
 
However, CR does require a commitment, especially to learning how the
TMS tables are linked.
 
I suggest taking the Gallery Systems CR class to learn TMS table linking
and CR.
 
David Parsell
Yale University Art Gallery
 
 
At 05:25 PM 12/6/2002 +0000, Jonathan Thristan wrote:
>Hello TMS Users!
>
>At Tate we use TMS to record details of all of our Displays and 
>Exhibitions. Curators and Registrars both agree that the inability to 
>specify sort orders (via a drop down?) for the lists of Object and 
>Loans within the Exhibitions module is a major drawback of the system. 
>It tends to mean that users view exhibitions information via reports 
>(e.g. for exhibitions a report exported into excel, sorted according to
 
>need), rather than via standard forms. Unfortunately, at Tate it has 
>also made some members of staff reluctant to use the system. Has 
>anybody else encountered this issue? Any thoughts?
>
>Regards
>
>Jon
>
>
>Jon Thristan
>Tate
>Systems Manager
>E: [log in to unmask]