a

Summary and Chart

This example shows how to create a report with the summary and chart on the same page.

Creating a new query

1. Create a new grid application based on the following SQL.

SELECT
products.ProductID,
categories.CategoryName,
products.ProductName,
products.UnitPrice,
products.UnitsInStock
FROM
categories INNER JOIN products ON categories.CategoryID = products.CategoryID

2. On the application menu open the folder Group By and click Select Fields

   

3.Select and enable the field categories.CategoryName.

4.On the menu Summary click in Charts and open the Chart Configuration (Flash)..

   

5. Configure image as below.

   

Showing only the Summary and Chart

6. In the application menu open the View and Settings.

   

7. Enable only the modules Summary and Chart.

   

8. Click the Run button on the toolbar.

   

Untitled Document

Rate this Tutorial
Bad Great
Leave your comments (optional).