New and Improved Datasets in Version 16.1

for Report Designer – Office Edition, Java Engine, .NET 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:
Datasets can be created by selecting the desired Datasource connection and clicking the “Data Set” button.

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.

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”

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);

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);

For over 10 years Windward has been making software that allows business users and developers to create data-powered reports, proposals, statements, and more within Microsoft Word, Excel, and PowerPoint environments with scalable high-performance output engines written for .NET, Java, and RESTful applications. Windward is proudly located in Boulder, Colorado serving over 70 countries around the world.

Contact

Got questions about reporting and document generation? We've got answers—let's connect!
Send a note