Average Daily Balance

[jgrether]

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.

[Francis aka khayman]

most probably you are using a relational report. you need to somehow add a row with zero values for those dates without activity

[BigChris]

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.