Hello!
I am tracking our company's inventory in a SSRS 2008 Tablix report. I am displaying the inventory for each day, at the end of the Month I need to display the Month inventory...basically the inventory on the last day of the month.
Select invDate, Branch, Month(invdate) as Month_, InvBalance From DailyInventory
Matrix row group=Branch column group=Month_, invDate
|