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