...
- In the Structure panel, right-click Data SourceSources and select Add Data Source (formerly Add Pentaho Dataset). A window opens where you can configure the query used in the data source.
- Select SampleData and click the Query Designer. Make sure your Hypersonic database is running before doing so.
- Select PUBLIC from the Choose Schema list box. The SQLeonardo window is loaded. From this window, you can select the tables/views to be included in the data source.
- Select the PRODUCTS table by clicking PREVIEW. This allows you to visualize the data in the table quickly.
- Click OK to close both windows.
The data source is added to the report. The Properties tool window displays the available columns and the data type of each column. Click Configure to change the configuration of a data source. The data source is now set up and installed correctly. You must now define the look of the report.
...