I have a report that shows all observations per day within a time period. I want to show 0 observations for days in the period when no observation happened. I could do this if I had a table of all dates, left-joining it to the observation table withWHERE on date, but I do not want to have to maintain such a table or have the user maintain it. I do have the user maintaining a table of holidays, and I can exclude weekends from consideration, but I want to include in the report non-holiday weekdays when nothing happened.
