Graph showing all

[wiplash]

We have a CR that includes a chart (currently a 3D bar chart) showing type and total number of recs for each type.

Example: There are 5 total type "A" records, 3 total type "B" records, no type "C" records, and 6 type "D" records.

Although in this case, there are no type "C" records, we still need to show "C" along with 0 records.

Crystal doesn't currently produce an entry on the chart for "C" because there's no records.

How can we do this?

 

[SkipVought]

Hi,

You need a list/table of all record types.

Then do a outer join that will list all the record types.