Jasper report yearly transactional data gouping

0
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: 2 years 11 months ago

1 Answer:

0

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

hozawa's picture
43199
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 week 6 days ago
Feedback
randomness