12 Jul 20182 minutes to read

The report data returns the result of an external datasource query value. The report data contains the datasource name, query, fields and parameter details in the report.

Add data

This section explains, how to create a new Data.

  1. Click the Data icon in the configuration panel to launch a Data configuration.

  2. Click the Add DataSet button in Data panel.

  3. Click Create New in the context menu, In the connection type panel, click the data source type that you want to connect. Here, SQL connection type is used to demonstrate.

  4. In the new data source configuration panel, fill the server name and related details.

  5. Click the Connect button, then the following view will be displayed.

  6. In query designer toolbar pane, you can set the dataset name of your choice by editing the Name field.

  7. You can drag the tables and views associated with the connected database from left pane. Dragged table or view from the left pane can be dropped into the center pane labeled with Drag and Drop tables here like below.

    After you drop the item into the center pane, it displays like below:

    Note: To search the table or view from the data collection, you can use the Search field in the left pane of the query designer.

Visualize multiple table data

You can visualize multiple tables by drag and drop another table into the design pane.

Now, the QueryJoiner dialog will be launched. You can relate the columns as desired. Refer Joining Tables.

Click the Finish button in the tools pane (highlighted below) to add the data with the report.

Now, you have successfully created a Data with the Web Designer Report. The table fields will be listed in Data panel like below.