+ 0 Votes That sounds more like Tony Hopkinson 7 years ago the query that's reporting the data, than crystal reports converting it into something printable. If you join say customers and orders only customers with orders will be printed. This is the standard join called an inner join. If you want to print out all customers whether they have an order or not, you have to convert it to an outer join. There will be some option in CR to give you this. Hit outer join in the help, it should tell you how. + 0 Votes Assign it to a variable Master_Techie 7 years ago Have you tried to grab the field value into a Formula? In there, you can decide what to display if the field value is NULL, or if the length of the field value is >0. Because EMPTY and NULL are two different values. + 0 Votes Change your query to avoid NULLs bruce.dimon 7 years ago I always use the ISNULL in my Crystal Reports queries on any field that can be NULL or is part of an outer join. This bug, excuse me, FEATURE is the main reason why. There's another reason to always use the ISNULL for Crystal Reports. Printing NULL or even blanks is rarely the best looking thing to put on paper. Instead of blanks, use "N/A", "not available" or "Unknown." After all, those words are a more accurate description of the data state than " "