Crystal Reports Another group for null values

Message

   Hi All,

I am having a Nul grouping issue.  I can't use a stored procedure, so that is out of the question.

I'll try to keep it simple.  My query is straight forward with all outer joins.
I need to get groups showing 0 results, but for different results within the group.

My out put currently looks like:

Region1
Product1  Volume1  Sales1

Product2  Volume2  Sales2

Product3  Volume3  Sales3

Product4  Volume4  Sales4

Region2
Product1  Volume1  Sales1

Product2  Volume2  Sales2

Product4  Volume4  Sales4

Region2

Product2  Volume2  Sales2

Product3  Volume3  Sales3

Product4  Volume4  Sales4

I need them all to show

Product1  Volume1  Sales1

Product2  Volume2  Sales2

Product3  Volume3  Sales3

Product4  Volume4  Sales4

My design looks like:

GH1 - Region
GH2 - Product   Volume   Sales

I can get a group formula to identify the nulls, but I need it to identify the nulls for ProductX of what is 0.

ex:  If isnull (Product) OR Product = "" the "No Volume"
       Else Product

I guess I'm looking for some ideas.  I don't usually have to do this within Crystal, but do it in a procedure.

Thanks!