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
Registrar
Van:
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
500
Phone: 317-275-1359
Fax: 317-275-1459
From:
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