Excuse my ignorance. What is a VCS?

I would suggest that you use a pre-populated dates table in your query and use this as the basis for your report. You might have a query something like:

SELECT DatesTable.Date,...