O'Reilly logo

iReport 3.7 by Shamsuddin Ahammad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Developing a bar chart report

Bar chart is another type of a chart where the options are shown as standing bars.

Suppose we want to see the sales volume of individual products, then we will use the bar chart. Follow the listed steps to create a bar chart report:

  1. Create another blank report, having just the Summary band visible and Band height big enough to place the chart element in.
  2. Open the Report query editor, and write the following SQL query:
    SELECT name,sum(salesQuantity)
    FROM Product, SalesLine
    WHERE Product.productCode=SalesLine.productCode
    GROUP By name
    
  3. Place a Bar chart on the Summary band.
    Developing a bar chart report
  4. Go to the Bar Chart - Properties, and enter"Sales ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required