SQL Server Reporting Services - purpose of global parameter

          

Interview questions

Purpose of global parameter, ReportServerUrl

Next>>         SQL Server tutorial  

SQL Server - Purpose of global parameter, ReportServerUrl - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

In Reporting Services there is a global parameter called ReportServerUrl. Explain its purpose

ReportServerUrl is the Url to access the Reporting Services webservices and Report Manager. These web services are used to access various reports. The Url precisely identifies the location of the Reporting server application on the network.

SQL Server - Purpose of global parameter, ReportServerUrl - May 05, 2009 at 22:00 PM by Rajmeet Ghai

In Reporting Services there is a global parameter called ReportServerUrl. Explain its purpose

ReportServerURL is used to set or get URL for the report server. Jscript uses get ReportServerUrl(uri value) and post ReportServerUrl(uri value). Uri is an object containing the URL for the report server.

SQL Server - Purpose of global parameter, ReportServerUrl - June 21, 2009 at 09:00 AM by Amit Satpute

ReportServerUrl displays the report URL.
The initial part of the value of ReportServerUrl is taken from the RSReportServer.config located in
C:\Program Files\Microsoft SQL Server\MSSQL.#\Reporting Services\ReportServer.

The URLRoot node of the config file can be either of:

Mid(Globals!ReportServerUrl,8,InStr(9,Globals!ReportServerUrl,"/") - 8) expression can be used to extract the IP Address or serverName

It extracts the name from the next character position of // to the next character position of /, which either is the server name or the IP address of the server.


Next>>

Also read

What is the actions prevented once referential integrity is enforced?

Answer - Following are the actions prevented once referential integrity is enforced......

What are the guidelines to use bulk copy utility of SQL Server?

Answer - While importing data, the destination table must already exist......

What are the ways to controlling Cursor Behavior?

Answer - Cursors behavior can be controlled by dividing them into cursor types: forward-only, static,........

What are the differences among batches, stored procedures, and triggers?

Answer - A batch is a group of one or more SQL statements. SQL Server compiles the statements......

What are the events recorded in a transaction log?

Answer - The start and end of each transaction......



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring