Crystal Reports on returns values that are not blank

Nicole Furnival
Nicole Furnival used Ask the Experts™
I am using Crystal Report XI. I am using a export from Raiser's Edge. When I enter the name field I get a list with 450 individuals, I then entered the following formula so that in the next field, I could see which ones which are Patrons with the following formula. If {CnMem_1.CnMem_1_Description}="" then "No" else "Yes". Now I only get a list of people who return a yes value to this question, and all the name that are not are left out of the report. In report options, this is what I have clicked. Convert Database Null Values to Default, Convert other null values to default. Can someone please let me know how to get all the constituents to be reported.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
IS that field in the same table as the names of the individuals?

If not you probably need to change the join between the tables to LEFT OUTER



Thank you so much, this is so greatly appreciated!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial