Wyn Enterprise allows you to use parameters to filter or add the data to display in reports at run time. You can either prompt users for parameters so that they control the output, or supply the parameters behind the scenes.
This tutorial guides you through the steps to create a parameterized report in Wyn Enterprise Report Designer.
Note: This tutorial uses sample SalesByRegion data set.
After you complete this tutorial, you will have a report that looks similar to the following.
(Parameter1 = Canada West and Parameter2 = 1004)
To create a databound table,
Note: The Data Set Name property of the table is automatically set to SalesByRegion.
Let us add two parameters that would act as filters for data retrieved from the data source, one would be passed as a filter for the region, and the other to filter the data according to store ids.
To add a report parameter that filters the data according to the region,
To add a parameter that filters the data according to the store id,
Set Data Type property to Integer and Prompt property to 'Enter Store ID'.
Go to From query tab and set the following properties as shown in the following.
To control the amount of data rendered in the report, we can add filters to the Table data region. In our report, we will be adding two filters such that the report renders data according to the user input in the parameters (Parameter1 and Parameter2).
Note: You may need to resize and reposition the controls on the report to accommodate data, and for a cleaner look.
Click Preview to view your report in the final output. You will be prompted to enter two parameters - select the region name and the store id for which you want to view the report, and again click Preview.
Note: The values in the Parameter list appear as sorted only if the data values are sorted in the data set.
Exit the preview mode by clicking Back on the left side of the designer.