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:
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
Harvard
Art Museum
32
Quincy Street, Cambridge, MA 02138