Summary and Pivot Chart
This example shows how to create a report with the summary and chart on the same page.
Creating a new grid
1. Create a new grid application based on the following SQL.
SELECT
C.CompanyName,
D.DeptName,
R.DateRelease,
R.ValueRelease
FROM
companies C INNER JOIN releases R ON C.CompanyID = R.CompanyID
INNER JOIN departments D ON R.DeptID = D.DeptID
WHERE
R.CompanyID not in (6,7,8,9) and
R.DeptID not in (6,7,8,9)
2. On the application menu open the folder breaks and click Select Fields.
3. Select and enable the fields CompanyName C. and D. DeptName.
4. In the application menu open the folder Totals and click Select Fields.
5. Check Sum in the field R. ValueRelease, as shown below.
6. On the Summary menu click Settings and open the Layout Settings.
7.Set according to the image below.
Displaying only Summary Pivot and Chart
8. In the application menu open the Grid and Settings.
9.Enable only the modules Summary and Chart.
|
|
|
 |
||
|
|
10. Click the Run button on the toolbar.
|
|
|
 |
||
|
|
| Rate this Tutorial | |||||||
|
|||||||
|
