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)
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:
For over 10 years, Windward has lead the industry with our world-class document generation platform that creates visually stunning, data-powered documents designed exactly the way users want and are created in a fraction of the time and cost compared to existing solutions. Proudly located in Boulder, Colorado, Windward Studios is the premier solution for developers and business users adding reporting and document generation capabilities to their applications in over 70 countries around the world.