Crystal Report is not displaying all records including zero value

Hi,

I am working on summary report that count the number of status for each department.

I need zero count of status to show on the report for rejected and failed status. The problem is it didn't show up when the report is generated. I have tried to follow solutions given by others but still cannot figure out how to fix this problem. The result that I get as follow:

The solutions/ suggestion that I have been tried as below:

1) Change the join type in query from inner join to left outer join.

2) In the report options menu, in the general settings I ticked the option 'Convert database NULL values to defaults' and 'Convert other NULL values to defaults'.

Does anyone have any ideas on how to display all records/ status including zero value?

Please help.

Thanks.