TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Content-Type:
multipart/mixed; boundary="_002_MN2PR12MB410924DB1878A3E070DB0BF5DEAC9MN2PR12MB4109namp_"
Date:
Thu, 16 Jun 2022 21:17:37 +0000
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
From:
"Smith, Jeffrey" <[log in to unmask]>
Message-ID:
In-Reply-To:
MIME-Version:
1.0
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Parts/Attachments:
text/plain (1424 bytes) , ObjCountsByLocation.RPT (115 kB)
This one might work for you. It's an older report that I used to count objects in each location.

Jeff

Jeffrey Smith
Assistant Registrar for Collections Information
Collections Department
Freer Gallery of Art and Arthur M. Sackler Gallery
Smithsonian Institution



@NatAsianArt
#SmithsonianAsianArt
asia.si.edu

-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Katie Keck
Sent: Thursday, June 16, 2022 4:40 PM
To: ListServ tmsusers <[log in to unmask]>
Subject: All Locations Report

Hi all,

Is it possible somehow to get a report that lists every location in the location authority as well as the number of objects housed in each location? We are currently on TMS2012 and I haven't been able to create a Crystal Report that performs this function. 

Thanks in advance!

Katie Keck
Associate Registrar, TMS
The John and Mable Ringling Museum of Art

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

ATOM RSS1 RSS2