Chapter 16: Let’s Get Together—Integrating OLAP with Your Applications 683
For k = 0 To CSet.Axes(1).Set.Tuples.Count – 1
DataGridView(j, k).Value = CSet.Cells(j, k, i).Value
'Place the DataGridView on the tab page
' Set the Buying Analysis group box visible
gbxBuyingAnalysis.Visible = True
Using Reporting Services
Without the Report Manager
The Report Manager provides a nice interface for ﬁ nding and executing reports but,
sometimes, the Report Manager is not the best way to deliver a report to your users.
Perhaps the user is browsing your website or using a custom application, and needs
to view a report. In these situations, we want to provide an integrated approach with
reporting available within the application. We want to deliver the report to the user
right where they are.
One way to execute a report without using Report Manager is through URL access.
URL access allows a browser or a program capable of issuing HTTP requests to
specify a URL and receive a report in the HTML report viewer. This URL can be
built into a standard HTML anchor tag to allow a report to be displayed with one
Basic URL Access
The basic URL used to access a report has two parts. The ﬁ rst part is the URL of the
Report Server web service. In a default installation, this is
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.
Chapter 16: Let’s Get Together—Integrating OLAP with Your Applications 685
In addition to executing reports, you can also view the contents of folders, resources,
and shared data sources. Try the following:
1. Enter this URL in the address bar:
2. Click Go. The contents of the MaxMinReports folder appears.
Figure 16-5 A URL-rendered report