This section describes simple steps to design a RDL report using the Standalone Report Designer. First, launch the
Bold Reports Designer application shortcut from your desktop/start menu.
The Bold Reports Designer will be launched with a new blank report.
Data Configuration panel. It opens the
New Data button in the data panel.
SQL type to connect the data.
Connect button. Now the following view will be displayed.
Here, an AdventureWorks database is used for the demonstration.
You can edit the name of the
Data in the Name field that is available in the toolbar pane.
The left pane holds the tables, views, and procedures associated with the connected database. Drag your preferred table or view from the left pane and drop into the center pane labeled with
Drag and Drop table here like below:
Now, the table will be dropped into the design area as shown below.
Run option in the tools pane.
Finish button in the tools pane.
Data panel as shown below.
The left pane in the design view consists of basic items, data regions, data visualization, and sub reports to design an interactive report.
Tablereport item is used for a demonstration.
Table item under
Data Regions in the item panel, then drag and drop it to the design area.
Table with two rows and three columns in the design area.
This step is applicable only for the report items that belongs to
Assign the dataset to the
Dataset property of the table.
ProductID into the
Content property of the table.
Data assign menu icon to open the data assign menu.
ProductID field in the table cell.
expression to the table cell.
=Fields!OrderQty.Value*Round(Fields!UnitPrice.Value,2) and click OK.
To improve the report readability, we can resize the table row height and column width.
PROPERTIES pane. This pane holds some general settings and some specific to the report item. Configure the desired settings on the table for better report design and to improve report readability.
Total and align the content to the
Data Assign menu. Then, click on
=Sum(Fields!OrderQty.Value*Round(Fields!UnitPrice.Value,2)) and click OK.
Now, the table design will look like below.
Once you are done with the report design to save a report, refer to the How to save report section.
Download the above report design from the link.