This section describes simple steps to design a report using Web Report Designer.
Data Configurationpanel. It opens the
New Databutton in the data panel.
SQLtype to connect data.
In the new data source panel,
Connectbutton. Now the following view will be displayed.
Here, an AdventureWorks database is used for demonstration.
You can edit the name of the
Data in the Name field that is available in 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 in the design area like below.
Runoption in tools pane.
Finishbutton in the tools pane.
Datapanel like below.
The left pane in the design view consists of basic items, data region, data visualization, and sub reports to design an interactive report.
Tablereport item is used for 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 table.
Data assignmenu icon to open 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 to the table for better report design and to improve report readability.
Totaland align the content to
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 designing, to save a report refer How to save report section.
Download the above report design from link
Link a Shared DataSource into a Report
Link a Shared DataSet into a Report
Create a Duplicate Copy of DataSource in a Report
Create a Duplicate Copy of DataSet in a Report
Add a Report Parameter to a Report