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
314.655.5408
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
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