AnsweredAssumed Answered

Group report by month

Question asked by JulianJohnson on Jan 19, 2012
Latest reply on Jan 19, 2012 by comment

Hi There,

 

I have a report that includes a date field (Invoice Due Date). I need to group these records by month & year. The SubSummary is set to show when sorted by due date and the script sorts by due date. However, it groups the records by the actual date rather than by month, which is what I need.

 

If I made calculated fields to return Month and Year I could sort by those but the subsummary only shows when sorted by one field.

 

I'm sure I'm missing something obvious but how do I get this working?

 

Thanks in advance.

Jules

Outcomes