Wyn Enterprise Documentation

Wyn Enterprise: Create Report

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, use 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
• Sort
• Auto Merge
• Group
• Add Parameter

Create Report

Create Report Layout

1. On the Document Portal, go to Create (+) > Create Report.
   
2. Select a template of the report. You can choose a Blank RDL Report, a Blank Page Report, or any other report as template from Categories.
   
3. Click Create Report.

Pick a Dataset

4. From the Data Binding tab on the right, select RetailDatasource dataset, which is already available to us, and click Add.
   
   
   This opens the Edit Dataset dialog with a default query.
   
5. Click Validate and then OK.

Create Databound Table

8. To view fields in the data set, click the drop-down next to the RetailDatasource dataset and enable Select Fields....
9. Select the fields required in the table and drag-drop onto the design area.
   
   A table with its columns bound to the fields is created. The Header row above the details row is automatically filled with labels.
   
   Alternatively, you can first drag-drop the Table data region onto the design area of the report and then populate the data by dragging and dropping the fields onto the details row.
10. Re-arrange the columns in the table such that it looks like as shown below.
    
    
11. We will now add a column after the Product field to display the total price for the products. Click inside the table to display the column handle, and then click the plus sign. It will add a new column to the table.
    
    
12. Select the details row of the newly added column and set the Value field to the following expression: {[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'.

13. Then, select the header row of the newly added column and enter the text 'Total Price'.
    The table will now look as shown below.
    
    

Preview and Save

12. Click Preview to view the final output of your report.
    
    The output of your report will look similar to the following.
    
13. Exit the preview mode by clicking Back on the left side of the designer.
14. Click Save to open the Save (As) dialog box. Enter the report name and click Save Report.

In addition you can

• add comments
• specify the category if you want to categorize the report
• specify the roles to share the report with
• modify the commands to appear in the toolbar on previewing the report.

Sort

Let us sort the table data region in alphabetical order of retailer country.

1. From the adorner on the right side of the table, select Details Group.
   
   
2. Go to the Sort Expressions property, click Show Items, and then select Add Item.
3. Click the radio button to display the fields and select the 'Retailer Country' field. By default, the sort order is ascending. You can change the sort order to descending by clicking the descending icon.
   
4. Preview the report.
   

Auto Merge

Data in table or tablix data regions can be merged using 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:

• Never: are not merged.
• Always: are merged.
• Restricted: are merged only if the corresponding cells in previous columns are similarly merged.

Let us merge the detail cells for similar products for the corresponding similar retailer country.

1. Select the Product textbox in the Details Group row.
2. Go to the Properties pane and set AutoMergeMode property to 'Restricted'. This merges the cells in the Product column with similar products, provided the country is the same.
   
3. Similarly, select Retailer Country textbox in the Details Group row and set its AutoMergeMode property to 'Always'.
   
4. Preview the report.
   

Group

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.

1. Right-click the Table data region to view options in the context menu.
2. Go to Group and Insert Groups.
   
   This will add a row group above and below the details row of the table.
   
3. Select the first text box of the added row group and set its value as following, {Year} The table will now look as follows.
   
4. Now, from the adorner on the right side of the Table data region, select Table1_TableGroup1 row group, and go to the Properties pane.
   
5. In the Group Expressions property, click Show Items and then select Add Item.
6. Click the radio button to display the fields and select the Year field.
   
7. Preview the report. It will look similar to the following.
   

Add Parameter

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,

1. From the top right corner of Designer, click the Data icon.
2. Click Add next to Parameters. A parameter named 'Parameter1' is added.
   
   
3. Click Parameter1 to edit parameter properties.

4. First, set the Data Type property to String and then the Multivalue property to True. The parameter properties will now look as shown.
   
   

5. 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),

7. Select the table and go to the Properties pane.
8. Select the Filters property and click Edit.
9. In the Filters properties, click + Add to specify the filter conditions.
   
10. Click the radio button next to Filter Expression to display the fields and select 'Order method type'.
    
11. Click the drop-down next to Operator and select 'In'.
    
12. Click the radio button next to Filter Values and select 'Parameter1' from the list.
    
    The filters propertie should now look as below.
    
    The filter on the table data region is now added.
    
13. Preview the report to view the final output.
    The following image displays the report with order method types (parameters) selected as Telephone, Web, and Fax.
    
    See Using Report Designer for creating scenario-based reports.