Maja,

There are a few ways to do this, but the easiest is to make that section of the report a subreport, and then group by role. The group name will indicate the role, and if nothing shows, you'll see it there. If you only want vendors, then use the select feature to limit the subreport to only vendors.  Cheers, -Jeff
________________________________________
From: The Museum System (TMS) Users [[log in to unmask]] On Behalf Of Maja Clark [[log in to unmask]]
Sent: Monday, December 21, 2009 10:34 PM
To: [log in to unmask]
Subject: crystal report - constituent role - how to show only vendors & null values

Dearest Crystal Report Gurus,
I need to run a report for an object package that lists, among other things, the vendor name for each object.  Even if some records lack a vendor role constituent, I still want to see them.  How do I get the null values to show and stop the other constituent roles (e.g., artist) from appearing?
What’s the formula?!  Am I working with the right fields?


[cid:image001.png@01CA8263.5E40D200]


Thank you,
Maja



Maja Clark
Collections Manager, Shangri La
Doris Duke Foundation for Islamic Art
4055 Papu Circle
Honolulu, HI 96816
(808) 792-5506
www.shangrilahawaii.org<http://www.shangrilahawaii.org/>