Creating a chart based on grouped data

[tom.beckman]

Hello,

Fairly new to the iReport tool, and I'm having some problems with generating a basic report.

I have the following data as a result of an MSSQL query:

SampleTime	System	Poll Value
2/22/14 1:42	System1	0.95
2/22/14 1:47	System1	1.12
2/22/14 1:52	System1	1.03
2/22/14 1:57	System1	1.12
2/22/14 2:02	System1	1.02
2/22/14 2:07	System1	1.19
2/22/14 2:12	System1	0.98
2/22/14 2:17	System1	1.24
2/22/14 2:22	System1	0.95
2/22/14 2:27	System1	1.11
2/22/14 2:32	System1	0.94
2/22/14 2:37	System1	1.13
2/22/14 2:42	System1	1.03
2/22/14 2:47	System1	1.10
2/22/14 2:52	System1	0.88
2/22/14 2:57	System1	1.15
2/22/14 3:02	System1	0.90
2/22/14 3:07	System1	1.18
2/22/14 3:12	System1	1.00
2/22/14 3:17	System1	1.03
2/22/14 3:22	System1	1.13
2/22/14 3:27	System1	1.01
2/22/14 3:32	System1	1.14
2/22/14 3:37	System1	1.03
2/22/14 3:42	System1	1.19
2/22/14 1:43	System2	23.45
2/22/14 1:48	System2	23.54
2/22/14 1:53	System2	22.31
2/22/14 1:58	System2	22.64
2/22/14 2:03	System2	19.56
2/22/14 2:08	System2	28.29
2/22/14 2:13	System2	24.76
2/22/14 2:18	System2	25.26
2/22/14 2:23	System2	26.52
2/22/14 2:28	System2	25.90
2/22/14 2:33	System2	24.50
2/22/14 2:38	System2	27.00
2/22/14 2:43	System2	21.61
2/22/14 2:48	System2	23.63
2/22/14 2:53	System2	26.30
2/22/14 2:58	System2	29.00
2/22/14 3:03	System2	25.34
2/22/14 3:08	System2	25.58
2/22/14 3:13	System2	27.31
2/22/14 3:18	System2	26.01
2/22/14 3:23	System2	26.36
2/22/14 3:28	System2	21.63
2/22/14 3:33	System2	24.80
2/22/14 3:38	System2	27.99
2/22/14 3:43	System2	27.55
2/22/14 3:48	System2	28.36

What I am trying to do is just to show on page 1, a chart of the data for System1...On page 2, a chart of the data for System2

I have created a group band on system, and placed a time-based chart in the group summary.

The chart has as the Series Expression $F{System} -- Time Period Expression $F{SampleTime} and Value Expression $F{PollValue}

When I run the report, it shows system1 correctly, but on system2's chart it shows both series (System1 and System2 on the same chart)...I only want System2 to show

I have tried a few variations of the evaluation time on the chart...but I can't seem to figure out why the system is combining the two values.

i'm sure it's something pretty simple that I am just overlooking.

Any help would be greatly appreciated.