Aleesha,

I haven't looked at your report - but it sounds like you have a linking
issue. In SQL this is called a JOIN - It sounds like you have an INNER JOIN
instead of an OUTER JOIN. Make that change and your report should work.

For more infor about how joins work, try this:
http://scn.sap.com/docs/DOC-21495

~Chad

On Thu, May 17, 2012 at 12:09 PM, Aleesha Nissen
<[log in to unmask]>wrote:

> Dear TMS-Gurus,
>
> I should start out by saying that my expertise with TMS is very minimal
> right now and I am in the process of learning how to use Crystal Reports.
> When it comes to writing scripts or "a little SQL code" as I've heard
> thrown around, I am sadly weak. For my current museum I've been using
> reports borrowed from my last place of employment, but I've hit a glitch.
> If an object does not have anything entered for "Artist" then the report
> isn't pulling any information for the record; just a photograph. There are
> over 600 objects in our database that have nothing entered for artist, so
> I'm trying to find a work-around. Dimitry at Gallery Systems said I could
> write a formula, but I didn't understand how or where to enter it. I've
> included the report I've been using. Does anybody have any suggestions?
> Thanks in advance!
>
> Best,
>
> Aleesha Nissen
> Assistant Registrar
> Norton Museum of Art
> West Palm Beach, FL
> [log in to unmask]
> 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.