David -

 

Our reports are in 9.35, which I don't think can be opened in 9.2, but I
can say that our crate list includes two groups.  The first group is
shipment number (which helps is you run more than one record on the
report), the second group is crate number.  The name of the exhibition
is in page header, the ship to and from and shipment dates are in the
group #1 header section, the crate information is in the group #2 header
section, and the objects are in the details.  Our insured value for the
crate is in the Group #2 footer.  I can usually work around the printing
twice problem by being creative with these groups.

 

Our regular shipping receipts group by shipment number, and we don't
create crates for our non-exhibition shipments.  So for these, all of
the shipment information is in page header, and the objects are in the
details.  The signature line is in the group footer.

 

If ever a group isn't possible, I find sub-reports to be useful in
eliminating the printing twice problem.  My most frequent sub-report
application is for artist/makers because we have many records with
multiple artist/makers.  Rather than link the makers view into the
report, I create a sub-report and link the subreport in.

 

Hope this helps -

 

Ella

 

 

 

Ella Rothgangel

Collections Database Administrator

Saint Louis Art Museum

314.655.5408

[log in to unmask]

 

 

________________________________

From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of David Armstrong
Sent: Wednesday, November 14, 2007 1:55 PM
To: [log in to unmask]
Subject: Shipping Report

 

Hello all,

 

My name is David and I'm the DBA for the Museum of Contemporary Art in
Los Angeles, California.  I have inherited the TMS system from the
registrar's department.  We are currently running 9.20 on SQL Server
2000.  As soon as the guys at Gallery Systems get back to me with
upgrade instructions we will be moving to 9.35 on SQL 2005.

 

My question has to do with generating a shipping report for the
registrars.  I have the table structures from TMS but I am having
problems getting the joins done in such a way that they are all one to
one relationships.  My understanding is that for the report to run from
TMS the joins need to be one to one.  I've had some email conversations
with the guys in support (Dimitry and Brian) but so far we haven't been
able to come up with any sort of solution.  I'm reaching out to all of
you in hopes that someone out there has already slain this particular
dragon.

 

I need the following fields...

 

ObjectNumber

Lender (Constituent first and last name)

Title

Medium

Crate Number

Crate Dimensions

Crate Weight

Value

ShipFrom Geo & Address

ShipTo Geo & Address

 

I know where all of the fields are.  I have joined the tables together
but I get multiple records for each object number.  The "problem" is
that many times the objects have been shipped multiple times, or the
objects require multiple crates.  Those conditions are leading to
duplicates.

 

Any suggestions?  Any report examples that you can share?  Thanks in
advance!

 

 

David Armstrong

Database Administrator

MOCA  THE MUSEUM OF CONTEMPORARY ART