Hi all, 

For PHoto Services Department lableing needs the what Jon describes met our needs just fine, and easier, we can make as many copies as we need.  But when we started created media records for our Slide Library, that was a different story.   There's so much more information required in a small space and is different depending on the type of object. 

I worked on a slide label report also for about a year, but as we moved through different collections, the report got more and more complicated and I was trying real hard not to have many versions of the report. We blessed to get some help from our ITS department at this point.  A new view had to be created.  The report is slow, but it works and prints neatly on archival slide labels.  Depending on department or classification, info prints in different spots. We set up some term attributes to describe wether the slide is horizontal or verticle and the getty logo prints  to the left or right depending on which. We haven't yet tackled the collection of architecture slides, which I think will be another interesting challenge. The Slide Librarian did make some comprises and what the labels from TMS are simpler and less flexible than what they used to do, but it works because the underlying data is much cleaner.  

Attached is a sample saved in pdf format.  There are two labels for each slide media record. Front and back are printed in sequence starting from top left to right across.  I'm happy to share the report through the Gallery Systems web site, as a starting point, but wouldn't be able to support your ongoing use of it.  

Best wishes, 
Amy Noel
The J. Paul Getty Museum 

>>> [log in to unmask] 12/04/03 08:14AM >>>
Hello
Might it be possible to export from Crystal into Excel (write a view which pulls together/formats the data and a columnar format report) and then use the worksheet as a datasource to merge with a Word slide-label template?
Jon Thristan
Tate
London
 
 
        -----Original Message-----
        From: Jonas Karlsson [mailto:[log in to unmask]] 
        Sent: 04 December 2003 15:45
        To: [log in to unmask] 
        Subject: SV: Alternatives to Crystal Reports
	
	
        Hello David,
        I would recommend Oracles own reporting tool ( http://www.oracle.com/ip/bt_reportpop.html  ) it's probably one of the best on the market, Microsoft has on coming soon on mssql.
        Jonas Karlsson
        Moderna Museet
        Stockholm
                -----Ursprungligt meddelande-----
                Från: David Lower [mailto:[log in to unmask]] 
                Skickat: den 28 augusti 2003 21:42
                Till: [log in to unmask] 
                Ämne: Alternatives to Crystal Reports
        	
        	
                Does anyone use a database reporting tool other than Crystal Reports?  We at Emory University have been trying to make a slide label report for about a year now, and we just can't overcome some of the formatting limitations in Crystal Reports to make labels that are satisfactory.  We print a lot of information on each slide label, which requires a very flexible database reporting tool and good formatting controls.  We have an old slide label printing program called VRMS that works extremely well and has flexible formatting, but we can not replicate its usefulness in Crystal, despite a lot of training and time spent.
                 
                Microsoft Access does have the kind of flexibility we need, but does not communicate with an Oracle database well (which is what we are working with).  If there are other useful database reporting tools that you know of, particularly if there are any that are specialized in the area of slide cataloguing, I would welcome your guidance.  
                 
                Sincerely, 
                 
                David Lower
                Business Analyst, Emory ITD
                404-727-5115