Skip to Content
Sep 12, 2019 at 09:24 AM

Crystal Report is not displaying all records including zero value

955 Views Last edit Sep 12, 2019 at 09:25 AM 2 rev


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.



cr-3.png (7.3 kB)
cr-1.png (23.6 kB)
cr-2.png (29.7 kB)