This section describes simple steps to design a report using Web Report Designer.
Data Configuration
panel. It opens the Data
panel.
New Data
button in the data panel.
SQL
type to connect data.
In the new data source panel,
myserver.domain.com
.Connect
button. 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.
Run
option in tools pane.
Finish
button in the tools pane.
Data
panel 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.
Here, the
Table
report item is used for 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
data visualization
anddata region
category.
Assign the dataset to the Dataset
property of the table.
ProductID
to the Content
property of table.
Data assign
menu icon to open 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.
Open the 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.
Total
and align the content to Right
side.
Data Assign
menu. Then, click on Add Expression
.
=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