Originally posted by lockwelle
Just as an aside then, or an alternative solution...
Typically, to get all the dates, you would need a command or a datatable to select all the dates and then join to that (probably as an outer join) for the display in your report.
I unfortunately do not have a data table in my ERP database. How would I use a command to bring the dates in?
Unfortunately, the solution that i thought i found was only half good. It managed to bring in the intermediate dates however they were pulled in as big block and not as individual entries as desired. as seen in the below link
http://imgur.com/upncBhO