Jasper report yearly transactional data gouping

I have a collection with daily transactions data for a year in MongoDB.
I have to get the daily transaction details summary with totals of some fields.
How to achieve this in jasper report?
Transaction collection is having following fields:
id : 1
date/time : "2015-01-01T00:00:00 000Z"
Gross Sales : 500
SalesTax : 100
Cash Sales : 300
i want the output in following 3 format


dkk9034_1's picture
Joined: Mar 22 2016 - 8:12am
Last seen: 7 years 2 months ago

1 Answer:

Just create a Group on field id and create variables for your sum.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago