Wonderful - thanks for both of these. From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of French, Ariana Sent: Tuesday, July 28, 2009 11:16 AM To: [log in to unmask] Subject: Re: TMS Bibliography module and web publishing Depending on the context, I'll use either a UDF (e.g. in listview queries) to concatenate strings, or in the case of our bibliography report, a combo of Crystal Reports formulas. Example UDF (concatenates alternate numbers): CREATE function [dbo].[concat_altnums](@objectID varchar(50)) RETURNS varchar(200) AS BEGIN DECLARE @str varchar(200) SELECT @str = COALESCE(@str + ', ', '') + altnum FROM altnums WHERE id = @objectID and tableid=108 GROUP BY altnum RETURN @str END Example CR XI formulas (concatenates bibliography-related constituents): //@reset (place in group header) whileprintingrecords; stringvar x:= ""; //@accum (in details; suppress details section) whileprintingrecords; stringvar x; x := x + {Constituents.DisplayName} & ", "; //@displ (in group footer) whileprintingrecords; stringvar x; if len(x) > 2 then left(x,len(x)-2) & ', ' I think I originally got the CR formulas from something I read on Tek-Tips (tek-tips.com) - a great resource. Ariana From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Smith, Jeffrey Sent: Monday, July 27, 2009 3:30 PM To: [log in to unmask] Subject: Re: TMS Bibliography module and web publishing Jeri, So would I! I need a little technical help on this one - in the form of variable arrays. When I get it figured out, I'll be happy to share. From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Moxley, Jeri Sent: Friday, July 24, 2009 4:44 PM To: [log in to unmask] Subject: Re: TMS Bibliography module and web publishing Jeff Steward - I'd love to see an example of your use of global variables for concatenating one-to-many. I've been reading up on this and have made some initial attempts, but have not yet met with success. Thanks! Jeri From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Smith, Jeffrey Sent: Friday, July 24, 2009 4:07 PM To: [log in to unmask] Subject: Re: TMS Bibliography module and web publishing Thanks, Jeff. It's good to get this advice - we've had a 'hold' put on our migration, and it's not such a bad thing, as I'm playing catch-up with the more technical part of my homework! From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Jeff Steward Sent: Friday, July 24, 2009 3:56 PM To: [log in to unmask] Subject: Re: TMS Bibliography module and web publishing Hi Jeff, We publish our bibliography cross-references to the web. Here is an example: http://harvardartmuseum.org/collection/detail.dot?id=1953.41%20&collecti onID=21009&collectionItemID=21013 It is possible to concatenate items in a one-to-many relationship in Crystal Reports using global variables. I had just worked on a report or two that does this with constituent phone numbers. I'll pass one along once I locate it. You might have an easier time if you shape some of the data in SQL Views and UDFs or even in a query in a Crystal Command. Jeff -- Jeff Steward Digital Information and Technology Department 617-495-0785 [log in to unmask] Harvard Art Museum 32 Quincy Street, Cambridge, MA 02138 www.harvardartmuseum.org <http://www.harvardartmuseum.org/> -----Original Message----- From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Smith, Jeffrey Sent: Thursday, July 23, 2009 3:53 PM To: [log in to unmask] Subject: TMS Bibliography module and web publishing Dear fellow TMS users, I am curious to know who among you is fully using the Bibliography module to record published references for objects, and at the same time currently publishing (or planning to) publish these citations to the web. The Bib. module & the way it is viewed/accessed from the Objects module is lacking in some features, and yet seem the best way to standardize the recording of this information. I've been playing with Crystal reports formulas to take all this data and concatenate it into a line which adheres to the Chicago Manual of Style. Pretty darned difficult when you have 2 or more authors. I'm hitting the limit on what I can do with it. Also, how do you mark whether the link between an object and bibliography module record is a "published reference", or a "bibliography" one? Thanks for any advice you can provide! - Jeff Jeffrey Smith Assistant Registrar for Collections Information Freer Gallery of Art and Arthur M. Sackler Gallery 1050 Independence Avenue SW MRC 707, P.O. Box 37012 Washington, DC 20013-7012 www.asia.si.edu [log in to unmask] tel: 202-633-0348 / fax: 202-633-9770