Line chart problem

[naveenchanda]

Hi,
I have a problem with displaying line report, in which i have used my report query as:

My report query is as follows:
SELECT YEAR,NOMESGSENT,NOUSERSREG,COMPANY FROM TABLE_USERS

In which i have set chart properties as:

series expression: $F{YEAR}
category expression:$F{NOMESGSENT}
value expression:$F{NOUSERSREG}
My data in the database as

YEAR NOMESGSENT NOUSERSREG COMPANY
24-JAN-08 5000 900 IDEA
24-FEB-08 3000 500 AIRTEL
24-JAN-06 2000 1000 AIRTEL
24-JAN-07 2000 750 VODAFONE
24-MAR-08 1000 650 VODAFONE
24-FEB-08 2500 630 IDEA

After compiling and executing the report will coming successfully but not exact as line graph.

This attached file gives you an idea, that what i got output.

Please help me to move forward.

Thanks and regards,
Naveen
[file name=Line.pdf size=19798]

[bklawans]

What do you want the chart to show?

 

The biggest problem is you are using $F{YEAR} as the series expression, but in you data the YEAR field is actually a date, not a year. This means every date in the database creates a new series, which is its own line.

 

Ask yourself what do you want the X and Y axises to show. The X axis is the category, the Y axis is the value. If you want more than one data point at each X axis point, use multiple series.

 

Given your data, what you want to display isn't obvious. Is it the value of nomesgsent and nouserreg by date? Or by company?

 

-Barry

[naveenchanda]

How can i add more than one data point using multiple series ?

 

Please explain me the steps.

 

Naveen

[sangi]

copy and paste the following expression in SeriesExpression tab

 

new java.lang.Integer(1) :)

 

You will find the line!!!