Contact Support
DataSource
12 Jul 20182 minutes to read
The DataSource
contains the connection properties or reference to an existing datasource in RDL.
Add a new DataSource
To bind data to a report item, a minimum of one data source is needed. A data source can be created through the below steps:
-
In the configuration panel, click the
Data
icon to launch aData
configuration panel. -
To create a data source, switch over to the data source panel using the switcher icon on the top-right corner of the
Data
configuration panel.
-
Click the
DataSources
in context menu, theDataSource
panel will be loaded. -
In the
DataSources
configuration panel, click theNew DataSource
button. In the connection type panel, choose the data source type that you want to connect. Here,SQL
connection type is used to demonstrate.In the new connection configuration panel,
-
In Name, specify the data source name without special characters.
-
In Server Name, you need to select existing server in the local network from the drop-down list or specify the specific remote server name like myserver.domain.com.
-
In Authentication Type, choose
Windows
orSQL Server
authentication. -
In Username and Password, specify the
username
andpassword
of the server. -
In Database name, choose or enter a existing valid database on the specified server e.g. AdventureWorks.
-
-
Finally, click
Save
in theNew Connection
panel and the new data source will be added in datasource pane like below.Now, the datasource will be added in the report and it is ready to create/use the data.