v2.0.0
v2.0.0v1.2.0

Tutorial 1: 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 is fetched from the data set added to the report.

This tutorial guides you through the steps to create a tabular report.

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

Tablular Report

Bind Data to Report

  1. Create a new report. By default you have a blank RDL Report.

  2. Connect to a data source.

    1. Go to Data tab and click Add.

    2. In the DataSource dialog, provide the following URL as Endpoint for the Remote JSON provider:

    https://demodata.grapecity.com/northwind/api/v1/Customers
    
  3. Add a dataset.

    1. Click Add Data Set for the added data source.

    2. In the DataSet dialog, enter the Json Path: $.[*].
      See Databinding for information on connecting to data sources and adding datasets.

Create Data-bound Table

  1. Expand the dataset fields and enable Select Fields...
    Selecting dataset fields

  2. Select the required fields and drag-drop onto the design area.
    Tablular Report in 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 Table toolbar icon onto the design area of the report and then drag-drop fields onto the details row.

Sort Table Data

Apply sort on any field in the table data in ascending or descending order. Let us sort our table data by customerID 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.
    sorting in Tablular Report

  2. Click Show Items and then select Add Item.

  3. Click the radio button to display the fields and select the customerID 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. Click descending Sort Descending Icon icon to sort the customerID field in descending order. You can change the sort order to ascending by clicking the ascending Sort Ascending Icon icon.

Group Table Data

You can organize the table data in groups to add more meaning to the table. Let us group the table w.r.t. country field such that our table displays unique country values.

  1. From the adorner on the right side of the Table data region, select <Details Group>, and go to the Properties pane.

  2. In the Group Expressions property, click Show Items and then select Add Item.

  3. Click the radio button to display the fields and select the Title field.

    Grouping Tabular Data

Add Page Header

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

  2. Drag and drop a TextBox control Textbox toolbar icon in the header area.

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

Customize the Appearance of Report

Customized Tabular Report

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

  1. To customize the Page Header, set the BACKGROUND - Color property to '#f1f1f1'.

  2. Select the text box containing the text 'Customer Report' and set the following properties.

    Property Value
    TEXT - Color #3da7a8
    TEXT - Font Size 16pt
    TEXT - Text Align Left
    TEXT - Vertical Align Middle
  3. To customize Header row of the table, set the following properties for all text boxes in the row.

    Property Value
    BORDER - Width 0.25pt
    BORDER - Style Solid
    BORDER - Color Gainsboro
    TEXT - Text Align Left
    TEXT - Vertical Align Middle
  4. Similarly, customize the text boxes in the Details row of the table.

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.