684 Delivering Business Intelligence with Microsoft SQL Server 2005
where ComputerName is the name of the computer hosting the Report Server.
This is followed by a question mark and the path through the Reporting Services
virtual folders to the report you want to execute. The Home folder is the root
of this path, but it’s not included in the path itself. The path must begin with a
forward slash (/).
Let’s try an example. We can execute the Inventory Levels By Month
Report. This report is in the BIStudioDeploy folder inside of the
In the examples used throughout the rest of this chapter, we assume Reporting Services is installed on
your computer. The localhost name is used to access Internet Information Services (IIS) information
on this computer. If you have Reporting Services installed on a different computer, substitute the
name of that computer in place of localhost in the following examples.
1. Start Internet Explorer.
2. Enter the following URL in the address bar:
Inventory Levels By Month Report
3. Click Go. The Inventory Levels By Month Report appears in the browser as
shown in Figure 16-5. Note the parameters area and the report toolbar in the
browser above the report.
When your URL is submitted, it is URL encoded. Some of the characters in your URL may be replaced
by other characters or by hexadecimal strings, such as %20. This ensures the URL can be interpreted
correctly when it is sent to the web server.
As with the Report Manager, Windows Integrated Security is being used when
a user executes a report through URL access. The user must have rights to execute
the report; otherwise, an error results. However, because the user is not browsing
through the folder structure to get to the report, the user does not need to have any
rights to the folder containing the report. You can use this fact to hide a report from
nonadministrative users who are browsing through folders in the Report Manager,
while still making the report accessible to someone using URL access.