Navision Report Group by Year,.

I have a table with the following structure.

empid transdate amount

101 01-10-2010 200

102 01-05-2011 350

101 20-10-2010 200

102 01-10-2011 20

I want to create a report that will group by YEAR (i.e 2010, 2011) and under each group the detail will display but my problem is to extract the year and group by the year.

Please i need help in this regards.

Thanks in advance.

I would work with the Date table and create a DataItem structure like this:

Date (Filter: “Period Type” = Year)
→ MyEntries (Filter: transdate = Date.“Start Date” … Date.“End Date”)

No need to extract anything.