Yes, indeed! You’ve found the culprit!
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Morgan, Amber
Sent: Monday, March 18, 2013 2:50 PM
To: [log in to unmask]
Subject: Re: Length of Display report
Oh wait – I think I’ve tracked it down. The filter is looking at the loan status per object – I see where that is. And that would make sense; we don’t always use that field, and it matches up with which loan records run on the report and which don’t. Thanks!!
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Morgan, Amber
Sent: Monday, March 18, 2013 3:42 PM
To: [log in to unmask]
Subject: Re: Length of Display report
Hmmm… do you know if it is looking at the “overall loan status” field on the General tab, or is it looking at the text entry on the Statuses tab? That could very well be our problem…
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll
Sent: Monday, March 18, 2013 3:31 PM
To: [log in to unmask]
Subject: Re: Length of Display report
Also, the report filters by Loan Status = Pending and Approved. So if you don’t use or have this field so defined, then it won’t pull those records.
Christine
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Hansen, Stephanie
Sent: Monday, March 18, 2013 1:55 PM
To: [log in to unmask]
Subject: Re: Length of Display report
Hi Amber,
There is something about Crystal Reports dropping records in the GS extras called fix crystal runtime. There's a script you can run to fix it. Maybe that's the ticket?
Stephanie
On Mon, Mar 18, 2013 at 1:44 PM, Morgan, Amber <[log in to unmask]> wrote:
Is anyone using the Length of Display report in TMS? I think it came with TMS2010. I admit that I’m pretty terrible when it comes to SQL and Crystal Reports. When I look at the report in Crystal, I’m not entirely sure which fields it’s looking at. I do know that when I run the report, the results are incomplete. I’m trying to compare loan records that show up in the report against the ones that don’t and I haven’t found the trigger yet. Is there some criteria a loan record must have in order to get it to show up on the report?
Thanks,
Amber
the warhol:
Amber E. Morgan
Associate Registrar
117 Sandusky Street
Pittsburgh, PA 15212
T 412.237.8306
F 412.237.8340
E [log in to unmask]
W www.warhol.org
The Andy Warhol Museum
One of the four Carnegie Museums of Pittsburgh
Email newsletter http://members.carnegiemuseums.org/email
Membership http://members.carnegiemuseums.org/SupportCMP
The information contained in this message and/or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Any views expressed in this message are those of the individual sender.
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.
--
Stephanie Hansen
Rights & Reproductions / Database Administrator
Milwaukee Art Museum
700 N. Art Museum Dr. | Milwaukee, WI 53202
Tel. 414.224.3268 | Fax. 414.271.7588 | [log in to unmask]
OPENING FEB 22
COLOR RUSH
75 YEARS OF COLOR PHOTOGRAPHY IN AMERICA
More at www.mam.org
Kids 12 and under are FREE
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.
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.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.