Windward Core is now Fluent by Apryse. Click here to experience the new and improved platform!
< Back to Features

New and Improved Datasets

Version
All Products
Designer
Artist
Scout
Javelin
.NET Engine
RESTful Engine
Java Engine

Datasets have been re-written from scratch to be more powerful and easier to use. Unlike our previous Datasets (which required being saved in a POD file to utilize in the Windward engines), new Datasets can be used like all other Datasources. This makes Datasets easier to manage and deploy in an application.

Creating a Dataset

Datasets are created in the Connection Editor for valid Datasource Providers. Valid Datasource Providers include:

  • SQL Datasources (Microsoft SQL Server, Oracle,MySQL, or DB2)
  • XPath 2.0
  • JSON
  • OData

Datasets can be created by selecting the desired Datasource connection and clicking the “Data Set” button.

Windward Datasources box adding data sets
Connection Editor

This creates an empty Dataset based on the selected Datasource. Next, create a query for the Dataset by either manually entering a query or by using a Wizard. When you’re finished editing a Dataset, click “Update” to save all changes.

Windward Datasources box adding sqlserver
Select datasource in Connection Editor

Dataset Usage in the Report Designer – OfficeEdition

In version 16.1, Datasets can be used just like Datasources.

Dataset Usage in the Java Engine and .NET Engine RunReport

To use a Dataset with RunReport, add the following parameter:

-dataset:name “ds=dataSourceName;select=theSelect”

  • name is thenickname of the Dataset
  • dataSourceName is the name of the Datasource that the Dataset is based on  
      This Datasource must also be defined in theRunReport parameters
  • theSelect is the query for the Dataset

Dataset Usage in the Java Engine API

To create a Dataset with the Java engine API, use the following code snippet:

DataSourceProvider datasource = new DataSetDataSource(dsName, select, parentDataProvider);

  • dsName is the nickname of the Dataset
  • select is the query for the Dataset
  • parentDataProvider is the Datasource that the Dataset is based on

Dataset Usage in the .NET Engine API

To create a Dataset with the .NET engine API, use the following code snippet:

IReportDataSource datasource = new DataSetImpl(dsName, select, parentDataProvider);

  • dsName is the nickname of the Dataset
  • select is the query for the Dataset
  • parentDataProvider is the Datasource that the Dataset is based on

Apryse Software Corp. © 2024 All Rights Reserved.