When you generate a report, chart data is collected and stored within the chart's dataset.
The dataset types are:
Think of a dataset as a table. Each dataset has different columns (fields). When a new record is put in the dataset, values are added to the fields.
Every report has a main dataset defined during its creation. But sometimes we need fields that are not returned by a query from the main dataset, or fields in a different data source. The dataset element allows you to define many datasets inside a report, each with its own fields and data source. Every dataset is independent, so its fields are separated from those of the main dataset, and from those of other datasets.
Creating a Dataset
| 1. | Right-click the report root node in the outline view and choose Create Dataset: |
| Create Dataset |
|  |
| 2. | In the Dataset wizard, name your dataset, choose Create new dataset from a connection or Data Source and click Next. The Dataset - Data Source window opens. |
| Dataset - Data Source Window |
| |
| 3. | Select Sugar CRM - Database JDBC Connection. |
| 4. | Enter the following query: |
select * from orders
| 5. | Click Next. The Dataset - Fields window opens. |
| Dataset - Fields |
| |
| 6. | Select the dataset fields you want and move them to the Fields list on the right and click Next. |
The Dataset - Group By window opens. This is where you can choose fields to group by, and choose whether to use group fields as sort fields.
| 7. | Do not select any fields to group by. Click Finish. The dataset you created in the Outline view appears. |
| GroupData Data Set |
| |
Recommended Comments
There are no comments to display.