12 Jul 20186 minutes to read
This section describes simple steps to create a report with Web Report Designer control. An AdventureWorks and Northwind database is used to demonstrate each of the features in the Web Report Designer.
Connecting to data
Add a new data source by establishing a data connection with any of the supported data connection types like below:
Setting up connection
Please find the steps below to set up connection for creating a RDL Dataset which will contains the information needed to retrieve a specific set of data from a data source,
Dataicon in the configuration panel to launch a
Next, click the
Add DataSetbutton in
Create Newin the context menu, it will launch connection type panel. In the connection type panel, click on the data source type that you want to connect. Here,
SQLconnection type is used to demonstrate.
In the new data source configuration panel, fill the server name and related details.
Connectbutton. Now the following view will be displayed.
You can enter the query directly in the Query Editor or use the Query Designer to build the query interactively and view the result of the query. Here, the data is created with the help of the Query Designer.
Build query using the Query Designer.
The left pane holds the tables and views 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:
After dropping the table, you can find below changes in UI:
The dropped table name will be pre-appended with tick mark in the left pane to indicate the specific table is in use like below:
The primary key defined in the connected database table will be marked like below:
The data type of the each column is represented with visual icons as shown below:
Add more than one table by following the same drag and drop procedure as mentioned in above steps, if required.
You can find more configuration options for dropped table such as,
Renaming column options. For detailed information, refer Rename Columns.
Filtering out specific data from huge database by using Data Filters.
Note: At present, you can experience full fledged query design for SQL data connection only.
Build query using the Query Editor.
To switch over to Query Editor, click the switcher icon in the designer toolbar.
You can visualize the data by using
Execute option from the tools pane in data design view.
Now the data will be retrieved based on the specified query.
Finish button in the tools pane to add the data with the report.
Now, the table fields will be listed in
Data panel like below.
Adding a report item to design view
The item panel in left pane consists of Basic Items, Data Visualization, Data Regions and SubReport that you can utilize to design a report.
drag and drop report items into the
Body of design area.
Note: You can only drag and drop
Basic Itemscategory into the
Enable header and footer
You can enable and disable header/footer by clicking the below icons from the designer toolbar pane.
Drag Drop Items
Click and drag the preferable report item from the item panel by holding the mouse left button and drop into the design panel like below:
You can resize the dropped report item by placing the focus over the report item and dragging its corner like below, if required.
You can move the dropped report item by clicking and dragging the move icon placed at top corner of selected report item like below, if required.
Assigning data to report item
Note: This step is applicable only for data visualization items like charts and grids.
To bind the data to a report item that is placed in the design area, focus on that report item.
Propertiesicon in the configuration panel.
Now, the report item properties panel displayed like below:
Datatab in the properties panel. Now, the data assign tab switches like below:
Data assign panel shows the data configuration view. The numeric columns are listed under the
Measures section; other type columns are listed under the
Data Assign Options
Drag Drop Measure Element
Select and drag the numeric column (measure element) from the
Measuressection that you want to visualize the data and drop into the
Now, the report item preview will look like below:
Settingsicon (highlighted below) to open the aggregation type drop-down list.
You can set the aggregation type by which you can compute the selected column.
Drag Drop Dimension Element:
Select and drag the dimension element from the
Dimensionssection to measure against any of the selected numeric column(s) in
Y Value(s)section, and drop into the
Now, the report item preview will look like below:
You can group the added column element with another column, by adding the respective dimension element into Row(s) section.
Now, the report item design will look like below.
You can filter the data from getting bounded to report item, by applying filters to the selected measure type or dimension type columns.
Configuring report item
Navigate to the properties pane in the properties tab.
This pane holds some general settings and some specific configuration settings to the report item.
Note: You can add more report items by following the above procedure.
To Preview report refer Preview Report.
To Save report refer Save Report.