Database Reference
In-Depth Information
InSTAllIng THe RePoRTIng
SeRVICeS SAMPleS
The chapters that include Reporting Services samples include
files with an
.RDL
extension in the ZIP. Despite the guidance
given in this chapter for the general best practice of using shared
data sources, these
.RDL
files will all contain an embedded data
source, which you will need to edit to point to your restored
databases.
To do that, open Report Builder 3 (available for download at
www
.microsoft.com/en-us/download/details.aspx?id=6116
),
and then select File
a
Open, browse to the
.RDL
file you
extracted. Next, right click on the data source and click Data
Source Properties as shown in Figure 8-8.
Finish by changing the server name to the machine you are
working on—often, if you have a default instance, you can sim-
ply use “.” to access your local server. The data source screen is
shown in Figure 8-9.
FIguRe 8-8
Changing a data source
FIguRe 8-9
Changing a data source
