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.
Note: This tutorial uses sample CustomerOrders data set.
After you complete this tutorial, you will have a report that looks similar to the following.
To create a databound table,
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.
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.
Re-arrange the columns in the table as shown in the following image.
Note: The Data Set Name property of the table is automatically set to CustomerOrders.
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.
Note: You can also enter a sort expression in the Expression Editor: Data - Sort Expressions dialog by selecting Expression...
Note: You may need to resize and reposition the controls on the report to accommodate data, and for a cleaner look.