Create an embedded dataset

This section guides you to create an embedded dataset in Bold Report Designer.

Design query data

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

   

2. Click on the New Data button in Data panel.

   

3. 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 on the Connect button, now the following view will be displayed.

   

6. You can edit the name of the Data in the Name field that is available in toolbar pane.

   

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:

   

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

   

Save Data

1. Click on the Finish button in the tools pane.
2. Your dataset should now be listed in the Data panel like below.
3. Expand the icon to view the data fields.