One chart in each group

[mquinteiro]

Hi, I'm using Jasper Report Studio, and I'm cat achieve make chars with the info of a group.

I have a data view similar to this one, lets call it sales

 

Product	SaleDate	Qtty
A	2018/01/05	7
A	2018/01/05	6
B	2018/01/05	1
B	2018/01/05	4
A	2018/01/10	2
A	2018/02/05	7
A	2018/02/05	6
B	2018/02/05	1
B	2018/02/05	4
A	2018/02/10	2

I whant to do a report with groups by month. In each month I want a chart with the sales of each product (Y) by day of the month (X) and series by product

So I did a report with the query

select product.SaleDate, sum(Qtty) from sales 

In the report I whant to have a Group band called MonthGRP

And in that group I want the chart.

In the detail I want all the sales of that month.

The problem is that I only get total chart (not grouped by month) in each Month.

I've tryed to put the reset field to MonthGRP but then I only get the first month all months.

[riodavid]

Hi mquinteiro,

Set the [Evaluation Time] of your chart to [Group].

BR

D