Databases Reference
In-Depth Information
URL access
URL access in SQL Server Reporting Services enables you to send commands to the
Report Server through a URL request. Using this you can customize the rendering
of a report on a Native mode server or in a SharePoint library by sending a request
to the Report Server. The request command can encapsulate report parameter values,
page related values, and a lot of others. There are predefined URL access parameters
that you need to use. You can e-mail the URL with parameters so that others can
access your reports (assumes email recipients have access to report server.)
These are some of the other actions you can perform via URL:
• Send commands to the HTML viewer, such as adjusting its look and feel
• List the children of a folder
• Retrieve the XML definition of an item on the server
• Render a specific report history snapshot
• Manage report sessions
The syntax for addressing an URL is as follows:
rswebserviceurl?reportpath [&prefix:param=value]...n]
Here is an example we saw earlier in
Chapter 2
,
SQL Server Reporting Services 2012
Projects with Visual Studio 2012
, where
rs:command=ListChildren
displayed the
folder contents on the Report Server
Kailua
.
A complete list of URL access parameters is available at
http://msdn.microsoft.
com/en-us/library/1c3e680a-83ea-4979-8e79-fa2337ae12a3
. We will revisit
this topic in
Chapter 8
,
Reporting Services and Programming
, section on
URL Access
,
and
Chapter 10
,
Applications Accessing Report Servers
,
Hands-on exercise 10.2
.
Search WWH ::
Custom Search