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]