How to intergrate group data into ONE chart ?

[lovetide]

First, congratulations on the new home of JasperReports & iReport & JasperIntelligence !

(This question is original posted at sf.net)

Suppose the following data set:

Code:

I want the following result/goal:
(1).

Code:

(2).
A chart contains two series: 1st is DialIn_Count series, 2nd is DialOut_Count series.

Before I use crosstab, I can use report group to group out DialIn and DialOut separately, and each group contains a chart which contains 1 series. So, none of them meet my requirements.

After I used crosstab, I achieved the first result/goal, but I still can't get 2 series in ONE chart, so, is there a way to achieve it ?

Thanks !

[Giulio Toffoli]

Hi liu,

attached there is the solution to your problem
solved using a chart (absolutly unuseful) and
a crosstab (that is what I think you need).

Attached there is a CSV file to test the jrxml
using a CSV datasource.

Please note that the crosstab is at the end of the report.

Giulio [file name=lovetide.zip size=16740]