Fill Empty Dates In A Matrix Ssrs

I am trying to find a way to fill dates that have no data in a matrix. What I have right now is below But I want to show all the dates in between as well. I have tried several dif

Solution 1:

1. Declare Months table with full date of month

Example:

declare@tbMonthasTable (DayOfMonth nvarchar (10))
insertinto@tbMonth ('01 Feb')
insertinto@tbMonth ('02 Feb')
insertinto@tbMonth ('03 Feb')
insertinto@tbMonth ('04 Feb')

... and so on

2. union @tbMonth with your output table, and group by [DayOfMonth], Sum([Your required columns])
3. Done.