Hi Lucille,
Here is another report (permanent collection label, in my case) that will help you in sorting by object package sort, in short what you need to do is add a parameter to your report that will take an object package name. And then in the Select Expert – Record you will need to equate vgsrpPackages.Name to your parameter, see below.
Hope this helps,
Olga.
[cid:image001.png@01CF80AE.CC153340]
...........................
Olga Zotova
Coordinator, Collections Database Administration
Collection Information & Resources
AGO – Art Gallery of Ontario
416.979.6660 ext. 262
[log in to unmask]<mailto:[log in to unmask]>
www.ago.net<http://www.ago.net>
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Smith, Jeffrey
Sent: Thursday, June 05, 2014 9:16 AM
To: [log in to unmask]
Subject: Re: Report Help
Lucille,
Here’s a report that uses a parameter so users can tell it which object package sort order to use. Users must have the package objects as their current TMS selection, and then give the package name to the report. I recommend copying and pasting the package name from “Selection Is” to avoid misspelling.
There are a bunch of formulas in here that you will need to delete and replace with your own data, as they refer to our own SQL views and such.
But the basic set-up of the report does allow users to sort by the order within a particular package.
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Lucille Stiger
Sent: Thursday, June 05, 2014 8:17 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Report Help
Good Morning Everyone!
At the Allen, we have a sweet report that produces a list with images ordered alphabetically by artist and and then by accession number. It's attached in case you would like to use it. It's the report that is used here most often.
Can anyone tell me how to sort this report so that the records appear in the same order as they do in the object module from which the report is being run? In other words, someone creates an object package with the objects listed in a particular order. The package is executed and now you see the same records in the same order in the object module. I want to print out the list with images report in this same order.
I would think that this would be something that is commonly done and hence should be easy to do. But, I can't figure it out.
Any help would be much appreciated!
Sincerely,
Lucille
--
Lucille Stiger
Registrar
Allen Memorial Art Museum
440.775.8668
To unsubscribe, send an email to [log in to unmask]<mailto:[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]<mailto:[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.
Now open! Francis Bacon and Henry Moore: Terror and Beauty - the AGO brings together two giants of 20th-century British art in a major exhibition of sculpture and paintings.
This message is a private communication. It may contain information that is privileged or confidential. If you are not the intended recipient, please do not read, copy or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it and any attachments from your system. Thank you.
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.
|
