IN IREPORT 2.0.1 My DB query is Main DB Query : SELECT year_month, no_of_messages_sent, no_of_users_registered FROM Table_Users So from it I get the following 3 fields in the left bar of my main windows under Fields button Fields : : $F{year_month},: $F{ no_of_messages_sent };: $F{ no_of_users_registered } For a Pie CHART Select a chart from top pane, expand it in the page under Summary section Dbl click chart tab> “chart tab†> edit chart properties> tab “chart dataâ€> tab “Detailsâ€> You need to enter the following details here and it would give you the output. Key Expression : $F{year_month} Value expression : $F{no_of_messages_sent} Label Expression : $F{year_month} Bar-chart Dbl click chart > “chart tab†> edit chart properties> tab “chart dataâ€> tab “Detailsâ€> Category series Add a category …with these values Series Expression : $F{year_month} Category expression : $F{year_month} Value Expression : $F{no_of_messages_sent} Label: empty Post edited by: Mbhardwaj, at: 2007/11/16 04:11