TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

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

Print Reply
Subject:
Re: Problems with a report
From:
Aaron Zalonis <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Wed, 16 Jan 2019 19:26:46 +0000
Content-Type:
multipart/related
Parts/Attachments:
text/plain (97 kB) , text/html (8 kB) , image001.png (97 kB) 
Hi Fatima,
I will check this. Thanks!
Best,
Aaron

From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Mahdi, Fatima
Sent: Tuesday, January 15, 2019 4:47 PM
To: [log in to unmask]
Subject: Re: Problems with a report

Hi Aaron! Have you made sure that the link between your Objects table and your MediaXRefs table is an Outer Join and not an Inner Join? If it's inner, you won't see any record that doesn't have a media record.

Fatima

--

Fatima Mahdi
Collections Information Specialist/TMS

Virginia Museum of Fine Arts
200 N. Boulevard
Richmond, VA 23220-4007
T 804.340.1443

[log in to unmask]<mailto:[log in to unmask]>



[image.png]

On Tue, Jan 15, 2019 at 3:09 PM Aaron Zalonis <[log in to unmask]<mailto:[log in to unmask]>> wrote:
Hi, all,
I've managed to create a Crystal Report that goes haywire if an image is not present in the Object Record it's being run against. It acts like the object doesn't exist, instead of presenting all the information (title, medium, dimensions, etc.) that does exist in the object record (and just not including a blank image). There are potentially many points of failure with this, but I'm wondering if anyone has ever run up against this kind of thing. If so, where did the problem exist for you?
I'm really stumped on this one. The same thing (failure) happens in both TMS 2016 and TMS 2018.
Best,
Aaron

AARON ZALONIS
ASSISTANT REGISTRAR / DATABASE MANAGER

NASHER MUSEUM OF ART AT DUKE UNIVERSITY
box 90732  durham nc 27708-0732
t +1 919 684 1971
e [log in to unmask]<mailto:[log in to unmask]>

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.


--

Fatima Mahdi
Collections Information Specialist/TMS

Virginia Museum of Fine Arts
200 N. Boulevard
Richmond, VA 23220-4007
T 804.340.1443

[log in to unmask]<mailto:[log in to unmask]>
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] 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