Creating a crosstab report
Let's create a crosstab report in some easy steps, as follows:
- 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
- Select SalesDate, Name, and SalesQuantity fields, and create the report without selecting any groups.
- 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:
- Place a Static Text ...