Jasper report yearly transactional data gouping
<p>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?</p>

<p>Transaction collection is having following fields:</p>

<p>id              :   1</p>

<p>date/time       :   "2015-01-01T00:00:00 000Z"  </p>

<p>Gross Sales     :   500</p>

<p>SalesTax        :   100</p>

<p>Cash Sales      :   300</p>

<p>i want the output in following 3 format</p>

<p>![1 Week Data][1]</p>

<p><img src="https://i.stack.imgur.com/adNNb.jpg" alt="Yearly data on monthly basis"></p>

<p><img src="https://i.stack.imgur.com/5XlAm.jpg" alt="Yearly data on weekly basis"></p>