I want to create a report that shows the average daily balance for a Cash account. I am trying to figure out how to force a row/date to show up if there is not any activity for that particular day.
So if there is activity for:
7/1
7/2
7/3
7/8
7/9
etc.. through 7/31
I want my report to show a balance on 7/4,7/5,7/6,7/7 even if there is no activity on those days. It should show the balance from the prior day. I am not sure how to force the report to display a day of there is not any activity (no Database rows) for that particular day.
most probably you are using a relational report. you need to somehow add a row with zero values for those dates without activity
You're going to need a calendar table and then put a left outer join to it. That way all of your dates will appear, with values against the ones that have data.