How to Display Reporting Service Reports without Authentication?

Expand / Collapse
 
     

How to Display Reporting Service Reports without Authentication?


The simplest way is to run an asp page that will fetch the report and display it.

You can do it with the following example code, just replace the URL with your own reporting url, login and password:

set objhttp = server.createobject("microsoft.xmlhttp")
url = "http://sqlreport01.mysite4now.com/ReportServer/webho_demo/Report1&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=True&rc:JavaScript=False&rc:LinkTarget=_top&rc:Area=Report"

objhttp.open "get", url, false, "login", "password"

objhttp.send
response.write objhttp.responsetext







Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:4/6/2009 7:03 PM
Last Modified By: Administrator
Type: FAQ
Article not rated yet.
Article has been viewed 1,004 times.
Options