Crystal Report Question

I'm designing a report and as an example, I'll say that I am using a field called COLORS. And during 2005 the Color Red was not used for any purchases. However, I still want the color RED to appear on the report with a zero in the monthly columns. I've tried everything to get this to work and I can't. Any suggestions, please?? Using an Oracle database.Do you want to show the field with red color if it is 0?|||No, I do not want to show a red color background if a value is zero. I want the COLOR field to show the name RED even if there is no data for that field up to this point in time.

So, for example, even if no RED color purchases were made I would still like RED to appear on the output of the report with a value of zero such as an example displayed below;

COLOR JAN FEB MAR APR

BLUE 10 10 10 10
GRAY 10 10 10 10
RED 0 0 0 0
BLACK 5 5 5 5|||I think you need to use Left Outer join in your SQL Query
What is your BackEnd?|||By BackEnd do you mean where does our data come from - it is an ORACLE database.|||If you use Joins then Use Left Outer Join