Wyn Enterprise provides a robust reporting environment for enterprise reports and ad hoc reports. With the help of Wyn reporting features, you can quickly create meaningful and beautiful reports with a lot of ease. The report designer also offers a huge variety of configuration options for the reporting controls that can be used to enhance the report appearance like the background color, font color, etc. or increase the report functionalities like embedding links to jump to another document, using data filters to display only specific information, and so on.
In this example, we will create a report in Wyn Enterprise and learn some basic concepts like sorting, merging, grouping, and working with parameters:
Create Report Layout
Pick a Dataset
Create Databound Table
{[Unit price] * Quantity}
Note: You can change the display format for the total price using the TEXT - Format property. In this example, the TEXT - Format property for the total price is set to 'Currency'.
Preview
Let us sort the table data region in alphabetical order of retailer country.
Data in table or tablix data regions can be merged using the AutoMergeMode property. The property provides three options - Never, Always, and Restricted. The detail cells with the same data values and with AutoMergeMode property set to:
Let us merge the detail cells for similar products for the corresponding similar retailer country.
Let us apply grouping to the table to view the details year-wise. We will use the table with sorting applied on the Retailer Country.
{Year}
Let us add a parameter that prompts the user to select multiple values. The selected parameters will act as a filter for data displayed in the table.
To add a report parameter that filters the data according to the order method,
First, set the Data Type property to String and then the Multivalue property to True. The parameter properties will now look as shown.
Go to From query tab and set the Data Set Name property to the added data set, Value Field property to 'Order method type', and Label Field property to 'Order method type'. The multivalue parameter is now added.
To add a filter that renders data according to the user input in the parameter (Parameter1),
Finally, click the Save button on the Menu Bar to save the report. Enter the report name in the Save (As) dialog box, and then again click the Save button. By default, the report is saved under the 'No Category' section of the Document Portal.
You can also do the following things when saving the report.