(Showing Draft Content)

Create Tabular Report

In tabular reports, the data is organized along the rows and columns of a Table data region. The data in the form of fields and entities are fetched from the data set added to the report.

The following videos demonstrate how to create a tabular report and organize data using grouping and sorting features.

Create Tabular Report

In this video, we will create a tabular product sales report.

Grouping and Sorting in Tabular Report

In this video, we’ll organize a tabular report using grouping and sorting features.

The following tutorial guides you through the steps to create a tabular report in Wyn Enterprise Report Designer.

What You Will Learn in This Tutorial

Note: This tutorial uses sample CustomerOrders data set.

After you complete this tutorial, you will have a report that looks similar to the following.

Tabular Report Example

Create Databound Table

To create a databound table,

  1. Go to the Data tab and click the drop-down next to the CustomerOrders data set. You can now see all the available fields in the data set.

  2. Enable Select Fields... and then choose the desired fields required in the table.

    Enable Select Fields option

  3. Drag-drop the selected fields onto the design area. A table with its column bound to the fields is created. You can see the Header row and Details row of the table are automatically filled with the data.

    Select Dataset Fields

    Alternatively, you can first drag-drop the Table data region 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.

  4. Re-arrange the columns in the table as shown in the following image.

    Table with filled data

Note: The Data Set Name property of the table is automatically set to CustomerOrders.

Sort Table Data

You can sort the table data of any field in ascending or descending order. Let us sort our table data by Price field in descending order.

  1. From the adorner on the right side of the table, select <Details Group> and go to the Sort Expressions property.

  2. Click Show Items and then select Add Item.

  3. Click the radio button to display the fields and select the Price field to sort the table by price.

    Note: You can also enter a sort expression in the Expression Editor: Data - Sort Expressions dialog by selecting Expression...

  4. By default, fields are sorted in ascending order. You can change the sort order to descending by clicking the descending Descending Icon icon.

    Sort Table Data

Add Page Header

  1. Go to the Report tab on top of the designer and select Add Header option.

    Add Page Header

  2. Drag and drop a TextBox control Textbox Control in the page header area.

  3. Click inside the text box and enter the text 'Customer Orders Report'.

Customize Appearance of Tabular Report

Customized Tabular Report Example

Note: You may need to resize and reposition the controls on the report to accommodate data, and for a cleaner look.

  1. Set the BACKGROUND - Color property for the page header and header row of the table to '#f1f1f1'.

  2. Align the text in the textboxes using the TEXT - Text Align (Left, Right, Center, and Justify.) and TEXT - Vertical Text Align (Top, Middle, or Bottom) properties. By default, these properties are set to General and Top.

  3. Set the font size for the text in the page header to '14pt' using the TEXT - Font Size property.

  4. Specify the border properties for the textboxes in the table using the BORDER - Width, Border - Style, and BORDER - Color properties. Set the border values to '0.25pt', 'Solid', and '#f1f1f1', respectively.

  5. Change the TEXT - Format property for the Price field to 'Currency'. This property displays the price values in currency format.

Preview and Save Report

  1. Click Preview to view the final output of your report.

  2. Exit the preview mode by clicking Back on the left side of the designer.

  3. Click Save to open the Save dialog box. Enter the report name and click Save Report.