Checked the concern about no data display in Daily Sales Report, as per checking in the query the cause is from the season code condition, then I add ifnull function to replace the null season code then test