One of the "beauties" of DAI is the drag&drop functionality, do a cross tabular and make one of the columns the month. All that from a table or join with a date column and without programming or creating a SQL view.

For more "sophisticated" reports we can use and advise what you suggest.