Show missing dates in sequence in crystal reports and add the data in that date row through report

Question

I want to show missing dates in crystal report column which does not exist in data base in SQL Server. Pattern is shown below In the image I tried to show that 11-12-2019 is missing date in this date want to show labor quota and as well its amount and idle amount respectively.

Answer 1

Create a Calendar table with one row for each date (if you Google that topic you'll find sample scripts for creating such a table).

Outer join from that table to your transaction table. And look for cases with NULL on the outer side.