That did it, thank you! At first the "Link Options" button was grayed out, but then it wasn't. I have no idea why it was grayed out to begin with or why it then became usable. On Thu, May 17, 2012 at 2:39 PM, Christine Droll <[log in to unmask]>wrote: > Chad has correctly diagnosed the problem with the join. Here’s the fix.** > ** > > ** ** > > **** > > ** ** > > *From:* The Museum System (TMS) Users [mailto:[log in to unmask]] > *On Behalf Of *Chad Petrovay > *Sent:* Thursday, May 17, 2012 12:02 PM > *To:* [log in to unmask] > *Subject:* Re: Report not pulling info without artist**** > > ** ** > > 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. * > *** > 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.