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 Configurationpanel. It opens the
New Databutton in the data panel.
SQLtype to connect the data.
In the new data source panel,
Connectbutton. 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.
Runoption in the tools pane.
Finishbutton in the tools pane.
Datapanel 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.
Data Regionsin the item panel, then drag and drop it to the design area.
Tablewith 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.
Contentproperty of the table.
Data assignmenu icon to open the data assign menu.
ProductIDfield in the table cell.
expressionto 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.
Totaland align the content to the
Data Assignmenu. 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.