André Straatman:
Hi, We are going to acquire Crystal Reports, so there is another
reason to have it. Thank you. You have been of great help.
Lourdes
From: The Museum System
(TMS) Users [mailto:[log in to unmask]] On Behalf Of André
Straatman
Sent: Tuesday, April 10, 2007 10:43 AM
To: [log in to unmask]
Subject: Re: TMS as a reminder tool
Hi,
It is possible through Crystal Reports.
You have to create a View in Sql Server first (a ‘union’
query), then you use this in your report.
The query lists all loans twice:
-with the beginning date substracting (-) days you want the
work(s) to be ready for shipment
-with the end date adding (+) days you must have the work(s)
be returned to your institution after the loan.
Add all other tables/fields in your report. Use Status-fields to
filter loans (for example: for loans that have left your institution but not
yet returned, loans that were in the past that are not needed in the report,
etc.) The view must be sorted by ‘plandatum’
Example:
CREATE
VIEW dbo.LOANSPLANNING
AS
SELECT
LoanID, LoanNumber, ConstituentID, 'begin' AS [begin],
CONVERT(datetime, substring(BeginISODate, 1, 4)
+ substring(BeginISODate, 6, 2) + substring(BeginISODate, 9, 2))
- 21 AS [plandatum], BeginISODate AS [totaaldatums]
FROM
Loans
UNION
ALL
SELECT
LoanID, LoanNumber, ConstituentID, 'eind' AS [begin],
CONVERT(datetime, substring(EndISODate, 1, 4)
+ substring(EndISODate, 6, 2) + substring(EndISODate, 9, 2))
+ 18 AS [plandatum], EndISODate AS [totaaldatums]
FROM
Loans
André Straatman
Registrar
Kröller-Müller Museum, Otterlo, Holland
Van: The Museum
System (TMS) Users [mailto:[log in to unmask]] Namens Kelly
Rushing
Verzonden: dinsdag 10 april 2007 16:09
Aan: [log in to unmask]
Onderwerp: Re: TMS as a reminder tool
Please respond to the list. I would also like to know if this
is possible. Right now, I enter all the expiration dates into my
Microsoft Outlook calendar and set it to remind me two weeks in advance.
I also have the calendar set to remind me to check for upcoming loan expiration
dates in TMS every month.
Kelly Rushing
Registrar
Eiteljorg Museum of American Indians and Western Art
500 W. Washington St.
Indianapolis, IN 46204
Phone: 317-275-1359
Fax: 317-275-1459
From: The Museum System
(TMS) Users [mailto:[log in to unmask]] On Behalf Of Lourdes M.
Ranero Guzmán
Sent: Tuesday, April 10, 2007 9:54 AM
To: [log in to unmask]
Subject: TMS as a reminder tool
Greetings fellow TMS users,
I have a question and hope anyone could answer me. We
want to use TMS as a reminder tool. Is there a way to set TMS to inform us when
is the due date for a loan or there is a due date for shipment?
Thanks.
Lourdes
M. Ranero
Museo
de Arte de Puerto Rico