Add the Report Data Source
We learned in Managing
Reporting Services: Data Connections and Uploads that when we refer to a data
source in Reporting Services, we are referring to a collection of
properties, in effect, that represents a connection to a given data
source. This collection of properties has a name, as it does in other
applications where data sources exist (a scenario with which most of us are
familiar). Data sources contain the following, where applicable:
of the data processing extension we use to process queries of the type for
which we intend to use the connection;
string that allows us to locate the source;
credentials involved in allowing us to read the data within the source.
As we have noted in
various articles of the series, a data source connection can be embedded
in a report (where it is typically defined within the creation process); it can
also be defined as a shared data source item that is managed by a Report
Server. The data source connection can be created either within the Report
Designer in Visual Studio .NET, or at within the Report Manager. In
this section, we will "import" the data source to which our sample
report clone is already pointed, to make things quick and easy. This way, we
can concentrate on Report Execution Timeout settings, the primary focus
of the article.
From within the
Solution Explorer, right-click the Shared Data Sources folder
that appears underneath the new RS015 project we created earlier.
on the context menu that appears.
Existing Item from the cascading menu that appears next, as shown in Illustration
Illustration 8: Select
Add --> Add Existing Item
Existing Item dialog for the project appears.
and select, the AdventureWorks.rds
file that we
copied to its new location,
as depicted in Illustration 9.
Illustration 9: Select the
AdventureWorks Data Source File in the Add Existing Item Dialog
is added to the
folder, as shown in Illustration 10. (The Shared Data Sources
folder is expanded in order to see the file.)
Illustration 10: The AdventureWorks.rds
File Appears within the Shared Data Sources Folder
that remains in our preparation phase is to add, test and publish the clone report.