Force Display of Group Name when summary value is null

[trwebster]

I'm using Crystal XI and I need to have all the names in a menu table display even if there is no match in another table.

This is what I have:

Menu_Problem table left joined to Cases table on menu_problem.value=cases.problem

I'm grouping on the field menu_problem.label and have running totals to summarize how the case was closed.

Sample Data
This is what I get:

problem Close Code A Close Code B Total
01 7 144 151
02 4 6 10
03 0 1 1
07 3 2 5

This is what I'd like to get:

problem CloseCodeA CloseCodeB Total
01 7 144 151
02 4 6 10
03 0 1 1
04 0 0 0
05 0 0 0
06 0 0 0
07 3 2 5

Is there a way in to accomplish this?

 

[lbass]

If your left join is FROM the problem table TO the cases table, then this should work--unless you have added selection criteria on the cases table, which would effectively "undo" the left join.

-LB

 

[trwebster]

All of my selection criteria is from the cases table, which is the main table. The problem table is just the table that translates the code for "problem" into an understandable label; it doesn't host any of the actual case data.

You did give me an idea that worked though. I moved my record selection criteria into the formula for my running totals. The report takes a little longer to run because it's pulling in over 100k records, but it gives me an accurate count of cases and shows all the problem labels. My boss will be so happy.

Thanks!