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

Creating a crosstab report

Let's create a crosstab report in some easy steps, as follows:

  1. Create a Blank A4 report. Enter Monthly Sales by Product as the Report name, and write the following SQL command as the report query:
    SELECT * FROM Sales, SalesLine, Product
    WHERE Sales.salesNo = SalesLine.salesNo
    AND SalesLine.productCode = Product.productCode
    
  2. Select SalesDate, Name, and SalesQuantity fields, and create the report without selecting any groups.
  3. Set the Band height of all bands to zero, except the title and the summary bands. Increase the summary band height. Now, the report layout will be as shown in the following screenshot:
    Creating a crosstab report
  4. Place a Static Text ...

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