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?