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]